Business days- how do I....

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
 
K

Kent

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
 
D

dream

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top