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
|