Business days- how do I....

  • Thread starter Thread starter dream
  • Start date Start date
D

dream

Hi there, how can I automatically (i.e. when I load the file) show ho
many business days have been reported.

For example, If I open up a file on Feb19th, I would like the formul
to count the number of workdays from Feb 1st to the 19th (i.e. 14).

I would also like it to recognize that once the month has changed t
refer to the beginning of the new month.

Lastly, can it also account for holidays?

Thank
 
Here's the gist as a formula:

=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(TODAY()),1),TODAY())

There is an optional holidays piece to this in the help.

Excel Support Technician
www.canhelpyou.com
 
thanks a lot. just a question, what does the '1' represent below
holidays? if not, how do i incorporate holidays using this formula, th
help didnt seem to provide any assistance.

=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(TODAY()),*1* ),
TODAY()
 
Back
Top