Calculate days between dates in Excel

  Jackcoms 18:30 06 Oct 2006

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


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 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?