ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   today's date (https://www.excelbanter.com/new-users-excel/232325-todays-date.html)

Aditya

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

RonaldoOneNil

today's date
 
=TODAY()

"aditya" wrote:

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


Jas

today's date
 


"aditya" wrote:

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

today's date
 
Hi,
=Today()

"aditya" wrote:

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


DILipandey

today's date
 
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.)


New Delhi, India


"aditya" wrote:

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



All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com