Hi

you can use the formula of
=TODAY()-1
this will, of course, update each day

Cheers
JulieD

"BARGAIN BIN" wrote in message
...
How do I get yesterdays date to automatically show in a cell?

Thank you,
Leonard

Excel 2002