problem with date calculations

  • Thread starter Thread starter Emmkaye
  • Start date Start date
E

Emmkaye

Hi folks, please help

Can you explain why i get the following different values
when using dates in calcualtions. if i enter 8/8/2003 in
A1 and 8/8/2003 in B1 and a formula in C1=B1-A1 i get the
answer 0, but if i enter a formula in D1=networkdays
(a1,b1) i get the answer 1 and formula in E1=workday(a1,4)
i get 14/8/03. this is more confusing if i put the
following values in A1=8/9/2003, B1=12/9/2003 then i get
the following answers c1=4, D1=5, E1=12/9/2003, why does
the Networkdays function appear to give an additional day
 
Hi

The NETWORKDAYS() calculates number of workdays in time interval, with start
and end dates included.
I.e. NETWORKDAYS(TODAY(),TODAY()) returns 1 when today is workday.


Arvi Laanemets
 
Back
Top