Calculating number of days including the start and end date
I need to calculate the number of days between two dates including the start
date and end date. (i.e., Start Date: April 3, End Date: April 5 - Answer would be 3, but I only get 2) Any info would be appreciated. Many thanks. |
Calculating number of days including the start and end date
Terri;250829 Wrote: I need to calculate the number of days between two dates including the start date and end date. (i.e., Start Date: April 3, End Date: April 5 - Answer would be 3, but I only get 2) Any info would be appreciated. Many thanks. Try =EndDate-StartDate+1 -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70098 |
Calculating number of days including the start and end date
As your existing formula is giving 2 and the answer you want is 3, your
solution is to add 1. Excel has an arithmetic operator + which does addition for you, so what you need to do is to append +1 to the end of your formula. -- David Biddulph "Terri" wrote in message ... I need to calculate the number of days between two dates including the start date and end date. (i.e., Start Date: April 3, End Date: April 5 - Answer would be 3, but I only get 2) Any info would be appreciated. Many thanks. |
All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com