View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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 :)