JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to make a list of all dates in 2021 that is 1 workday before middle of the month and 1 workday before the end of the month.
I have this, but not all values look correct:
e.g. 8 April 2021 which should be 13 April 2021
Formula in C3
Can anyone suggest correction? Ideally without hardcoding the number of rows as 27?
TIA,
Jack
I'm trying to make a list of all dates in 2021 that is 1 workday before middle of the month and 1 workday before the end of the month.
I have this, but not all values look correct:
31/12/2020 |
14/01/2021 |
28/01/2021 |
11/02/2021 |
25/02/2021 |
11/03/2021 |
25/03/2021 |
08/04/2021 |
22/04/2021 |
06/05/2021 |
20/05/2021 |
03/06/2021 |
17/06/2021 |
01/07/2021 |
15/07/2021 |
29/07/2021 |
12/08/2021 |
26/08/2021 |
09/09/2021 |
23/09/2021 |
07/10/2021 |
21/10/2021 |
04/11/2021 |
18/11/2021 |
02/12/2021 |
16/12/2021 |
30/12/2021 |
e.g. 8 April 2021 which should be 13 April 2021
Formula in C3
Excel Formula:
=WORKDAY(SEQUENCE(27,1,DATEVALUE("01/01/2021"),14),-1)
TIA,
Jack