Automatic date population

Solved/Closed
Krish - 14 Jun 2010 à 07:32
 Krish - 15 Jun 2010 à 08:10
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.
Related:

3 responses

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
14 Jun 2010 à 11:19
As formula or as value ?

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