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?
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))
Thatโs exactly what I needed. Thank you Suvrutt!
Good to know that the expression worked as per your need.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |