Evening all,

=TODAY()-WEEKDAY(TODAY(),3)
Could someone please explain to me exactly how this formula works?
If i put this formula in Excel today (monday) it will show me monday, if i change the 3 to a 2, it shows as sunday, if i change the 2 to a 1, it shows as saturday - but wont accept any other number?

Regards

Rich