View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default how to count easily

i am lost

You're not the only one!

With all these new rules it makes this extremely complicated.

Biff

"dribler2" wrote in message
...
another typos excuse,

date start = 2-jan-o7
date end = 4-apr-07 <@ 4months

the manual count of workdays (inclusive of given dates) = 78 (same as your
formula's result)

date start = 2-jan-o7
date end = 8-apr-07 <sunday

the manual count of workdays (inclusive of given dates) = 78
(but formula's result = 77)

i am lost
been dribled2