Result should be the number of weekdays only

[qwerty70]

I have a form based on a query. This form contains a "StartDate","EndDate" and "NumberOfDays". On the "NumberOfDays" text box it should return only the number of week days (i.e. excluding Saturday & Sunday).

Appreciate your help in advance.

Thanks,

qwerty70

 

[Bowers74]

Check out the NETWORKDAYS() function. It handles only weekdays (i.e. no Saturdays or Sundays) and can handle optional predefined holidays as well.

You will need to install the Analysis Tool Pack (under Tools->Add-Ins) to have this function available.

Peace!!

Mike

Didn't get the answers that you wanted? Then . . . Click Here

 

[Bowers74]

You should also check out my FAQ on Excel's date functions:

What are some of Excel's date functions?

faq68-4037



Peace!!

Mike

Didn't get the answers that you wanted? Then . . . Click Here