todays date on a sheet

[Don]

I want (todays date) that will update itself on a spreadsheet.
Is this possible? If so how?
Any ideas will be very helpful
Thanks

 

[Pete_UK]

Put this formula in the cell:

=TODAY()

and format the cell as a date in the style you wish.

Note that the date showing will change if you open the file on another
day.

Hope this helps.

Pete

 

[xlmate]

try
=NOW() or
=TODAY()
Format to the date format you want by right clicking on the cell,
choose Format Cells
select Date under Category in Number's tab
choose the date format you want under Type
click OK

pls note the date will change whenever you open the file.
Is this what you want?

HTH
--
Your feedback is appreciate, pls click on the Yes button below
if this posting is helpful
Thank You

cheers, francis