ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date (https://www.excelbanter.com/excel-worksheet-functions/245091-date.html)

Saran

Date

how to set the yesterday date and tomorrow date in sell by using formula?

Jacob Skaria

Date

=today()-1
=today()+1

Format it to your required format

If this post helps click Yes
---------------
Jacob Skaria

"Saran" wrote:

how to set the yesterday date and tomorrow date in sell by using formula?

Bernard Liengme[_3_]

Date

=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?

All times are GMT +1. The time now is 12:00 PM.