Yesterdays date in a cell?

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi

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

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

Thank you,
Leonard

Excel 2002
 
Hi Leonard,

Try
= Today() -1

This would keep on getting updated as per new days.

Regards,
Hari
India
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Go to a particular Cell -Date 1
today's date static 1
Pivot table macro filter data between yesterday and today (date+time) 0
Comparing two workbooks - Excel 2010 - not using Add-ins 2
Generate web address string from date range in column? 10
Compare shorter date range against longer date range 2
Excel High lightng dates in future, today and past 1
date stamp to keep date 2

Back
Top