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)