today's date

[aditya]

which formula should i use to insert today's date which update daily
automatically.

 

[RonaldoOneNil]

=TODAY()

 

[JAS]

which formula should i use to insert today's date which update daily
automatically.

=NOW()

In the cell were you want the date, but don't forget to format it, so it
shows up as a date, not a number.

 

[Eduardo]

Hi,
=Today()

 

[DILipandey]

Hi Aditya,

You can use following:-
=Today()
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
[email protected]
[email protected]
New Delhi, India