Date -2 without sundays

AppSheet AppSheet Q&A
1 
 

Hi, can somebody help me how should i refer to the date in the column two days earlier, skipping Sundays?

2

Your requirement could be clearer with more examples. The following expression will eliminate Sundays from the 2 days prior. So if the date is a Tuesday, it will show date of previous Saturday.

IF(WEEKDAY([Date])=3, [Date]-3,[Date]-2)

But can the date itself be Sunday and if so what result it should have for 2 days prior?

3 Likes
3

That’s exactly what I meant, thank you :grinning_face_with_smiling_eyes: Sunday will not be the chosen date.

2 Likes