Change to formula

[bbc1]

I am using this formula to display the current date on a sheet, I require it
to show the actual day before, what do I need to change.
=IF(AND(B6="",B4<>""),NOW(),IF(AND(B4<>"",B6<>""),B6,""))

 

[Bob Phillips]

=IF(AND(B6="",B4<>""),TODAY()-1,IF(AND(B4<>"",B6<>""),B6,""))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[bbc1]

Thankyou if works

=IF(AND(B6="",B4<>""),TODAY()-1,IF(AND(B4<>"",B6<>""),B6,""))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)