Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
which formula should i use to insert today's date which update daily
automatically. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
=TODAY()
"aditya" wrote: which formula should i use to insert today's date which update daily automatically. |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() "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. |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
=Today() "aditya" wrote: which formula should i use to insert today's date which update daily automatically. |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
How to use Today's date in a cell and make it stay the same date | Excel Discussion (Misc queries) | |||
I need today's date returned as date format in formula | Excel Discussion (Misc queries) | |||
Count number of cells with date <today's date | New Users to Excel | |||
count the number of cells with a date <= today's date | New Users to Excel |