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:00 AM

Add 1 to it?


=DATEDIF("1/1/23", "1/9/23","D")+1

2 replies

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.

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.