Recent content by alex148

Thank you.

I enter data in A1 and in B1 I have the following formula =ifA1=””,””,IF(B1=””,NOW(),B1)) which automatically populates today’s date in B1. This is great. However, this may sound odd, how can I make the time stamp be yesterday's date in B1 when I enter data in A1 today. The reason for is that...