how to set the yesterday date and tomorrow date in sell by using formula?
J Jacob Skaria Oct 9, 2009 #2 =today()-1 =today()+1 Format it to your required format If this post helps click Yes
B Bernard Liengme Oct 9, 2009 #3 =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
=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
