First Business Day of Next Month excel formula

[tonyjyoo]

Hello,

I need a formula that gives me the first business day of the next month according to a date in cell A1.

For example, if:

A1 = 7/29/16

I would like A2 to read = 8/1/16

Please and thank you!

 

[Eric W]

Maybe:

=WORKDAY(EOMONTH(A1,0),1)

You can build a list of holidays to include in WORKDAY if you like.

 

[tonyjyoo]

Maybe:

=WORKDAY(EOMONTH(A1,0),1)

You can build a list of holidays to include in WORKDAY if you like.

This works perfectly.

Thank you!

 

[FDibbins]

Or just this...
=WORKDAY.INTL(A1,1)

 

[Eric W]

Glad we could help.