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.