=TODAY()-1 and =TODAY() + 1
Of course, when you open the file tomorrow they will display new dates.

To enter today's date as a constant use CTRL+; (this will not update)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Saran" wrote in message
...
how to set the yesterday date and tomorrow date in sell by using formula?