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 13th working day was Thursday 14th September
- So if we look at October the 13th working day is Wednesday 18th October
- So if we look at November the 13th working day is Thursday 16th November
Data Source
Column 1 Data can be as simple as 01/01/2023 to 31/12/2023
Column 2 would be a formula that would flag what day is the 13th Working Day of Each Month?
e.g
Date 13th Working Day
Sun 01/01/2023 NA
Mon 02/01/2023 NA
Tue 03/01/2023 NA
Wed 04/01/2023 NA
Thu 05/01/2023 NA
Fri 06/01/2023 NA
Sat 07/01/2023 NA
Sun 08/01/2023 NA
Mon 09/01/2023 NA
Tue 10/01/2023 NA
Wed 11/01/2023 NA
Thu 12/01/2023 NA
Fri 13/01/2023 NA
Sat 14/01/2023 NA
Sun 15/01/2023 NA
Mon 16/01/2023 NA
Tue 17/01/2023 NA
Wed 18/01/2023 13th Working Day January
Any help comments or approqaches would be appreciated
Jimmy
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
