Weekend and holiday testing

[Hussein982]

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

[Qiu · Accepted solution]

@Hussein982 
I assume the publich holiday remains the the same day for every year.

[Hussein982]

@Qiu Just wanted to thank you for your prompt response. This is definitely helped me to solve the matter. 

Appreciate your time. 

[Qiu]

@Hussein982 
Glad to know it helps.

[Hussein982]

@Qiu I may have another question for you regarding pdfs files. What's the fastest wat to convert pdfs into excel?

[Qiu · Accepted solution]

@Hussein982 
I am sorry but I dont have experience on converting PDFs.
It is very tricky for me. 😑