=DAYS360

O

Owen

Is there a reason to use this formula for an aging calculation? I would think
to just take the current date minus the date of receipt to get the actual.
 
N

Niek Otten

In financial calculations it is quite common to assume a 360-day year, with
12 months of 30 days. There are special rules (in at least two versions),
that's why this function is useful.
 
Top