Help with a Weekday Expression

[elan_Bailey]

Hi all,

I’m trying to create an expression to auto-populate new forms with the date of the preceding Friday.

According to the help article (961346) on date and time expressions, this formula should work: TODAY() - (WEEKDAY(TODAY()) - 6)
(sorry the system won’t let me post the link to the appsheet help site)

But instead of populating the previous Friday, it populates the date of the upcoming Friday.
Any tips?

[Suvrutt_Gurjar]

Hi @elan_Bailey,

Could you please try an expression something like below -

IFS(WEEKDAY(TODAY())= 7, (TODAY() -1), WEEKDAY(TODAY())= 6, TODAY(), WEEKDAY(TODAY())< 6, TODAY()-(WEEKDAY(TODAY()) +1))

[elan_Bailey]

Suvrutt_Gurjar:

IFS(WEEKDAY(TODAY())= 7, (TODAY() -1), WEEKDAY(TODAY())= 6, TODAY(), WEEKDAY(TODAY())< 6, TODAY()-(WEEKDAY(TODAY()) +1))

That’s exactly what I needed. Thank you Suvrutt!

[Suvrutt_Gurjar]

@elan_Bailey

Good to know that the expression worked as per your need.