# of Working Days in a Month

[#1]

I am trying to build a formula that will give me the # of working days in the current month.

Right now I am using the following formula to try and calculate it but I am unable to get it to work

=NetWorkDays(Min(Month(now())), Max(Month(Now())))

What formula should I be using to accomplish my goal

Thanks

[MayilVahanan]

Hi,

=NetWorkDays(Min(Monthstart(Today())), Max(MonthEnd(Today())))

Hope it helps

[#3]

Thanks for the quick response. That works great. How would I account for the one holiday we have had this month?

[MayilVahanan · Accepted solution]

Hi,

=networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

Hope it helps

[nagaiank]

You may use this also:

=NetWorkDays(Monthstart(Today()), MonthEnd(Today()))