Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: WEEKDAY.INTL function

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: =WORKDAY(EOMONTH(B4,0)+1,-1) Explanation Working from the…