View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Counting # of days between 2 dates excluding Fri & Sat)

Hello Jarek,

The formula looks fine, maye you got an input date wrong - perhaps got
tricked by Excel "auto century guess" 1900 resp. 2000?

But if you want to count single weekdays there is a better non-
volatile formula:
http://www.sulprobil.com/html/date_formulas.html

Regards,
Bernd