Yesterdays date in a cell?
 

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

Yesterdays date in a cell?
 

How do I get yesterdays date to automatically show in a cell?

Thank you,
Leonard

Excel 2002

Yesterdays date in a cell?
 

Hi Leonard,

Try
= Today() -1

This would keep on getting updated as per new days.

Regards,
Hari
India

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

Thank you,
Leonard

Excel 2002

Yesterdays date in a cell?
 

Hello Leonard
=TODAY()-1
HTH
Cordially
Pascal

"BARGAIN BIN" a écrit dans le message de
...
How do I get yesterdays date to automatically show in a cell?

Thank you,
Leonard

Excel 2002

Yesterdays date in a cell?
 

Thank ya'll
Leonard

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

Thank you,
Leonard

Excel 2002