WEEKDAY.INTL function in Excel

Excel Date and Time Functions return a dynamic date or time in a cell.

Get last working day in month in Excel

If you need to determine the last working day of a given month and year, then this tutorials is for you. To get the last working day in a month, you can use the WORKDAY function together with the EOMONTH function. See example below: Formula =WORKDAY(EOMONTH(date)+1,-1) > In the example, the formula in C4 is:… read more »