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

[justchris]

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


thanks
chris

[mnewdick]

Try =now()-1

[justchris]

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

[mnewdick]

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!