Calculate days between dates in Excel

  Jackcoms 18:30 06 Oct 2006
Locked

I need an Excel formula which can count the number of days between dates. The answer must include both the start date and the end date.

For instance, if I have 2 October 2006 in one cell and 6 October 2006 in another cell; the total number of days is 5 including both the first date and the last date.

How do I calculate this in Excel?

Thanks in anticipation.

  VoG II 18:34 06 Oct 2006

=DATEDIF(A1,B1,"d")+1

where the earlier date ia in A1, the later date in B1. Format the result cell as Number.

  Jackcoms 18:48 06 Oct 2006

Thanks for your quick response. Problem solved!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?