Calculate days between dates in Excel

  Jackcoms 18:30 06 Oct 06

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 06


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

  Jackcoms 18:48 06 Oct 06

Thanks for your quick response. Problem solved!

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

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This stop-frame animation tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…