todays date on a sheet

D

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
 
P

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
 
X

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top