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.

Numbers formula for total days between 2 dates including 1st and last

datedif gives the difference between 2 dates .....datedif 01/01/2023 01/09/2023 D is 8

but I want to include the 1st and last day so 9 days

I can't find a formula in HELP & I've checked various sites on Numbers but no dice

Any help with the Numbers formula would be helpful

Thanks



iMac 21.5″ 4K, 12.6

Posted on Apr 28, 2023 8:51 AM

Reply
Question marked as Top-ranking reply

Posted on Apr 28, 2023 9:13 AM

Yes - my error was to put the +1 within the brackets


Simple really


Thanks very much


2 replies

Numbers formula for total days between 2 dates including 1st and last

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