fill in dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel Ed 2002
I know how to make a date in a cell to automatically update each time I open
the
spreadsheet. what I am wondering is can I make it show the day before for
example today is 9/25, when I open the spreadsheet it will say 9/24. Is this
possible? Thanx.
 
Put the following formula in the cell where you want the date displayed:

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-1)
 
Excel Ed 2002
I know how to make a date in a cell to automatically update each time I open
the
spreadsheet. what I am wondering is can I make it show the day before for
example today is 9/25, when I open the spreadsheet it will say 9/24. Is this
possible? Thanx.
Click to expand...

Or simply:
=Today()-1
 
Back
Top