Hi All:
I would like to flag expenses incurred on weekends AND holidays for further review.
The excel file I have contained thousands of transactions from 2023 and 2024. The transaction date format I have in my excel file as follow (i.e. 12/11/2023 month/day/year)
The formula should also catch the Canadian publics holidays as indicated below:
Jan 1
Feb 19
Feb 20
March 29
April 7
May 22
July 1
Sep 4
Oct 9
Dec 31
| Record # | Transaction date |
| 1 | 1/1/2023 |
| 2 | 1/1/2024 |
| 3 | 5/4/2024 |
| 4 | 2/19/2023 |
| 5 | 12/25/2023 |
| 6 | 12/31/2024 |
| 7 | 4/5/2024 |
Thank you in advance for your help
