templates

is there a template for calculating the number of days between two dates when using numbers on an iMac mini


Posted on Apr 17, 2023 12:19 AM

Reply
Question marked as Top-ranking reply

Posted on Apr 17, 2023 2:18 AM

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:

DATEDIF – Apple Support (AU)


Regards,

Ian.


1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

templates

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.