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 responses

Answer 1 / 3

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Answer 2 / 3

Krish
Jun 14, 2010 at 12:44 PM

Yes i need that...The value date should change on the next day automatically.

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 14, 2010 at 01:20 PM

=if(a1="", "", today())

Answer 3 / 3

Krish
Jun 15, 2010 at 08:10 AM

Coooll...Riz..It's working fine!!