IntermediateDate & Time
Calculate invoice age with TODAY
Work out how many days old each invoice is.
TODAY
8 min25 points
TODAY
Returns the current date, updating each time the sheet recalculates.
Syntax
TODAY()
Date & Time.
A worked example
=TODAY()-B2
Returns 46
Days between the invoice date and today.
Where it goes wrong
Subtracting in the wrong order gives a negative age. It also recalculates whenever the sheet opens, which is the point — but means a saved snapshot will not match.
Practise TODAY
Knowing what a function does and being able to write it from memory are different skills. These close the gap.