Thread
:
How do I count the number of days from 1 date to another?
View Single Post
#
2
Posted to microsoft.public.excel.misc
RagDyer
Posts: n/a
How do I count the number of days from 1 date to another?
Just add 1.
=B1-A1+1
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Steve R" <Steve
wrote in message
...
I need to calculate the number of calander days from one date to another.
For example: if the start date is January 1, 2006 and the end date is
January
2, 2006, I need the answer to be 2. When I subtract January 1 from
January 2
I get an answer of 1. Please help.
Reply With Quote