templates
is there a template for calculating the number of days between two dates when using numbers on an iMac mini
is there a template for calculating the number of days between two dates when using numbers on an iMac mini
Hi shalomthomas78,
The DATEDIF function is your friend.
DATEDIF(start-date, end-date, calc-method) returns the number of days, months or years between two dates.
Formula in D2 (and fill down): DATEDIF(B2,C2,"D")
More on DATEDIF here:
Regards,
Ian.
Hi shalomthomas78,
The DATEDIF function is your friend.
DATEDIF(start-date, end-date, calc-method) returns the number of days, months or years between two dates.
Formula in D2 (and fill down): DATEDIF(B2,C2,"D")
More on DATEDIF here:
Regards,
Ian.
templates