Not that it makes any difference but since you want to count days you might
as well use
=D10-C10 format as general
and since you want to add one day use
=D10-C10+1
Regards,
Peo Sjoblom
"KimberlyC" wrote:
Hi
I have a "From" Date in Col C and and "To" Date in Col D.
In Col E, I have entred the following formula to calc. the number of days
between them =DATEDIF(C10,D10,"D")
( I'm trying to find the number of days each employee worked for the year
( weekends do not matter..they are supposed to be included in this total
number))
If I have (for ex) 11/1/2004 in C10 and 12/1/2004 in D10, the answer I get
in E10 = 30.
The days should be 31 ( 30 days in Nov and 1 day in Dec).
Is there a different formula I should be using to get the correct days I'm
looking for.....
Thanks in advance for your help!!
Kimberly :)
|