Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Weekend and holiday testing

Hussein982
8 - Asteroid

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
11/1/2023
21/1/2024
35/4/2024
42/19/2023
512/25/2023
612/31/2024
74/5/2024

 

Thank you in advance for your help

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

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

1202-Hussein982.png

Hussein982
8 - Asteroid

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

 

Appreciate your time. 

Qiu
21 - Polaris
21 - Polaris

@Hussein982 
Glad to know it helps.

Hussein982
8 - Asteroid

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

Qiu
21 - Polaris
21 - Polaris

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

Labels
Top Solution Authors