Hi, can somebody help me how should i refer to the date in the column two days earlier, skipping Sundays?
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?
That's exactly what I meant, thank you ๐ Sunday will not be the chosen date.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |