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
