Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
Hi guys & gals,
I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
It's as simple as you think.
cell C2 should be B2-A2 Format as number. "K. Mack" wrote: Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
Hi
With start in A1 and end in B1 =B1-A1 Add +1 is if you want to include the whole of the first day and the whole of the last day -- Regards Roger Govier "K. Mack" wrote in message ... Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
=B1-A1
Must format as a number rather than a date! -- Gary's Student "K. Mack" wrote: Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
Just subtract them and format the cell as General.
=b2-a2 (or if you want to include one of the end dates) =b2-a2+1 (or +2 for both days???) K. Mack wrote: Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
As dates are whole numbers just subtract one from the other and format the
cell as general as it will automatically format it as a date Remember: you can't have negative dates in Excel (without some changes) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "K. Mack" wrote in message ... Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to d
That's the ticket! Thanks so much.
"Gary''s Student" wrote: =B1-A1 Must format as a number rather than a date! -- Gary's Student "K. Mack" wrote: Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
Hi Dave
(or +2 for both days???) No, just 1 to add. 05 Jan 07 - 01 Jan 07 = 4 Actual days 01,02,03,04,05 = 5 -- Regards Roger Govier "Dave Peterson" wrote in message ... Just subtract them and format the cell as General. =b2-a2 (or if you want to include one of the end dates) =b2-a2+1 (or +2 for both days???) K. Mack wrote: Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula to calulate number of days passed from date to date
Oops.
Roger Govier wrote: Hi Dave (or +2 for both days???) No, just 1 to add. 05 Jan 07 - 01 Jan 07 = 4 Actual days 01,02,03,04,05 = 5 -- Regards Roger Govier "Dave Peterson" wrote in message ... Just subtract them and format the cell as General. =b2-a2 (or if you want to include one of the end dates) =b2-a2+1 (or +2 for both days???) K. Mack wrote: Hi guys & gals, I am working on a spreadsheet that has a column with a start date and another column with an end date and the third column should total the amount of days between the two. I can't find a formula to do this. Any help would be greatly appreciated. I'm sure it's someting simple that I'm missing but I am almost ready to pull my hair out. Thanks. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel date scheduling not msProject | Excel Worksheet Functions | |||
Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
how to get the number of days between two date formatted fields in vba for excel? | Excel Worksheet Functions | |||
Excel running date formula minus weekend days | Excel Worksheet Functions |