Forum Discussion
Identify the Date of the 13th Working Date of Every Month
Hi All Im looking for a way of indentifying the 13th Working day of every month. Assume the Day 1 is the 1st working day of a month and some examples below So if we look at September the...
If your weekend is Saturday and Sunday, some of your examples are incorrect. Without taking public holidays into account, the 13th working day can only be the 17th, 18th or 19th day of the month.
In B2:
=IF(A2=WORKDAY(EOMONTH(A2,-1),13),"13th Working Day", "")
Fill down.
HansVogelaar Apologies for not replying. Your formula worked a treat. It blew my mind.
A big thanks for the assistance.
Jimmy