Yesterdays date in a cell?

J

JulieD

Hi

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

Cheers
JulieD
 
B

BARGAIN BIN

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

Thank you,
Leonard

Excel 2002
 
H

Hari

Hi Leonard,

Try
= Today() -1

This would keep on getting updated as per new days.

Regards,
Hari
India
 
Top