Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating number of days including the start and end date | Excel Discussion (Misc queries) | |||
Days between dates including start day and weekends | Excel Worksheet Functions | |||
I want to count days between two dates including start date | Excel Worksheet Functions | |||
Calculating Number of days from one date to another | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |