You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

templates

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