Tag: business
-
Calculate last business day in month with Excel
Here is a quick post to calculate the last business day in a month taking into account holidays. This is useful for with finance calculations and wanting to know a bank’s last banking day in a month. =WORKDAY(EOMONTH(A2,0)+1,-1,holidays!A:A) Where; Cell A2 is the reference month cell Range holidays!A:A is a list of holidays