todays date on a sheet
 

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

todays date on a sheet
 

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

On Jan 14, 4:54*pm, Don wrote:
I want *(todays date) that will update itself on a spreadsheet.
Is this possible? If so how?
Any ideas will be very helpful
Thanks

todays date on a sheet
 

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









"Don" wrote:

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