How to find the next business day after the last day of the month.

**[email protected]** · 02-06-2008, 07:30 PM

I'm creating a timeline for when tasks are due and want to know how I can get Excel to give me the date of the next business day after the last day of the month. For example, the last day of the month in February is Friday the 29th. I want Excel to give me the date of the next business day, which would be Monday, March 3. I know how to get the last day of the month using the EODATE function, but can't get it to add one business day in the same cell. Any suggestions?

**Dunc3142** · 02-07-2008, 02:20 AM

=EOMONTH(TODAY(),0)+CHOOSE(WEEKDAY(EOMONTH(TODAY(),0)),1,1,1,1,1,3,2)

You can replace both Today() functions with any date you choose in Quotes.

=EOMONTH("3/2/2008",0)+CHOOSE(WEEKDAY(EOMONTH("3/2/2008",0)),1,1,1,1,1,3,2)

**sprsbs3647** · 02-07-2008, 10:30 AM

This is awesome! Do you also know how to exclude holidays? Sept. 1 is Labor Day, so I would like it to skip that day and give me the next business day.

**Ron Coderre** · 02-07-2008, 10:49 AM

Since you apparently have the Analysis ToolPak add-in installed....
Try this:

A1: (a date)

H1:H10 contains your list of Holidays

Please Login or Register  to view this content.

Does that help?

**sprsbs3647** · 02-07-2008, 12:32 PM

I'm familiar with that function, but how can I nest it into the previous formula so that Excel tells me what the next business day is after the last day of the month?