=now() help.. can it display yesterday?

Was wondering if I could use the =now() to display yesterdays date?


thanks
chris

Try =now()-1

Thanks thats what I was looking for, Anyone happen to know if I can do something similar in the header using the &[date]?



Thanks
Chris

Try this ... ="My Header for date "&TEXT(A1,"mm/dd/yy")

Where cell A1 contains the date. You can specify the date differently, if you want ... for example: ="My Header for date "&TEXT(A1,"mmm dd, yyyy")

Hope that helps!