Pages tagged “dates”

6 pages in Cellwise.

1. Age or years between two dates (DATEDIF)

   Whole years and leftover months between two dates with DATEDIF.

   dates datedif

2. Calculate days overdue for an invoice in Excel and Google Sheets

   One formula that returns how many days an unpaid invoice is past its due date, and zero if paid.

   invoice dates freelancer

3. Days left, working days left and the pace you need

   Three formulas for a project deadline: days left, working days left and tasks per day needed.

   project tracker dates

4. Days overdue and a simple late fee for unpaid invoices

   Count days past due (zero if paid or not yet due) and work out a simple monthly late fee.

   invoice dates freelancer

5. Monthly totals by category with SUMIFS and EDATE

   Build a category-by-month grid from a list of transactions with one SUMIFS formula you can fill across and down.

   sumifs dashboard dates

6. Sum or count between two dates in Excel and Google Sheets

   Use SUMIFS and COUNTIFS with two date conditions to total or count a date range.

   dates sumifs countifs

All pages