how: if, conditional test, true (do nothing if false)

[jwhitney]

I want a simply if then without the else.

 

[bj]

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

 

[jwhitney]

We have daily and weekly (and monthly and biannual) checks, I want the date

 

[Bob Phillips]

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