Change to formula

  • Thread starter Thread starter bbc1
  • Start date Start date
B

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,""))
 
=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)
 
Thankyou if works

Bob Phillips said:
=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)
Click to expand...
 
Back
Top