How to get the last business day of the month.(Microsoft Excel)
Japanese version.
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 )
---
Links
Tips. Others.(Microsoft Excel)