Date -2 without sundays

[Chris3]

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

[Suvrutt_Gurjar]

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?

[Chris3]

That's exactly what I meant, thank you 😄 Sunday will not be the chosen date.