How to get the last business day of the month.(Microsoft Excel)

kohki08

2 weeks ago

Here is how to get the last business day of the month taking into account weekends and holidays.

Formula

Use the EOMONTH and WORKDAY functions.

=WORKDAY(EOMONTH(Date,0)+1,-1,Holiday cell range )

---