Subtitle: Data validation, conditional formatting, counts per status, a "stuck" flag, and a check that catches statuses typed by hand Written with AI assistance. I edited it. The formulas below were c
Subtitle: Due dates that skip weekends and holidays, working days left, and a "Remind now" flag with WORKDAY and NETWORKDAYS Written with AI assistance. I edited it. The formulas below were checked in
Many small businesses in India still make invoices in Excel. The one thing most DIY sheets get wrong is the tax split. Within your own state, GST is split into CGST + SGST. Across states, it's a singl
Total, order count, last order date and "gone quiet" flags per customer with SUMIFS, COUNTIFS and MAXIFS, plus a check that nothing was left out
Commas, currency symbols, hidden spaces, (brackets) and Dr/Cr turned into real numbers, with a check against the statement total
Sales, orders, refunds, running total and month-on-month change from a plain order list, plus a check that catches dates typed as text