=TODAY()-WEEKDAY(TODAY()-2)

--
HTH

Bob Phillips

"jwhitney" wrote in message
...
We have daily and weekly (and monthly and biannual) checks, I want the
date
on the weekly to update (dd/mm/yy) on "Mon" but not change the rest of the
week.

"bj" wrote:

=if(Condtion,true response,"")
will give a blank for a false response,
is this what you mean?

"jwhitney" wrote:

I want a simply if then without the else.