anything in Excel...

It's Excel-o-lozy...

Calculate First Business / Working / week day of the month - How through an Excel formula?

www.Excelolozy.com - To calculate First Day of next month is easy now as I have already shared it.

But how to calculate First BUSINESS / WORKING / WEEK Day of next month.

Business Day is the first Working / Week day of the month.
i.e. First day of the month on which we have to work. :(

It excludes Sunday and Saturday, Sat, only if is also an off :)
It is based on formula of getting First Day of Next Month.

and the formula is:
=EOMONTH(A1,0)+1+IF(WEEKDAY(EOMONTH(A1,0)+1,2)=6,2,IF(WEEKDAY(EOMONTH(A1,0)+1,2)=7,1,0))

Where:

A1 contains the value of specific date of the any month.

Result will be the First Working Day of the month next to the date quoted in cell A1.
Cool???

Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com 

0 comments: