Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
If they are legal Excel dates then =A1-B1+1 Where A1 is the End date and B1 is the start date. The format the cell to Number. If this helps, please click the Yes button. Cheers, Shane Devenshire "Terri" 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add 30 days to date in another column, including Sat/Sun? | Excel Worksheet Functions | |||
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 |