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.
=DATEDIF(A1,B1,"d")+1where the earlier date ia in A1, the later date in B1. Format the result cell as Number.
Thanks for your quick response. Problem solved!
This thread is now locked and can not be replied to.
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 ?
© Copyright 2017 IDG UK. All Rights Reserved.