Weekday Function in excel

[Alvin_C_Apostol]

Hi Everyone, 

Is there a way for me to do the operation below in alteryx?

so i have the computation below:

so the excel syntax is: =IFERROR($D2-(WEEKDAY($D2,2)-1),"""")

I am new in alteryx and I don't have an idea how to calculate it using alteryx

Hope someone can help me. 

thanks in advance 🙂

[jdunkerley79 · Accepted solution]

An equivalent expression would be:

DateTimeAdd([Date],1-ToNumber(DateTimeFormat([Date],"%u")),"days")

- DateTimeFormat([Date],"%u") will give you the WeekDay(,2) equivalent as a string

- ToNumber parses it to a number

- DateTimeAdd allows you to add a period to the date

Sample attached

[Alvin_C_Apostol]

This works great thanks for your help!