Automatic date population

Solved/Closed
Krish - Jun 14, 2010 at 07:32 AM
 Krish - Jun 15, 2010 at 08:10 AM
If i fill any data in cell A1 then automatically current date should get update in the next column B2.

Can this be done? Pls assist.

3 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 14, 2010 at 11:19 AM
As formula or as value ?

If you use formula and open the book tomorrow, it will have tomorrow date
0
Yes i need that...The value date should change on the next day automatically.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jun 14, 2010 at 01:20 PM
=if(a1="", "", today())
0
Coooll...Riz..It's working fine!!
0