Inserting a date field

[R2D2]

How can I insert a date field into an excel cell. I can do it in Word quite
easily but for some reason Excel presents more a a challange.

 

[Paul B]

R2D2, =TODAY() will give you today's date, is that what you need?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Gord Dibben]

Do you want a static date or an date that will change each day?

1. CTRL + ;(semi-colon) to enter a static date.

2. =TODAY() to enter a changing date.


Gord Dibben MS Excel MVP

 

[Guest]

You've got two good answers, and if you want to do something special, like
having a date appear in the next cell when you enter data in a cell, then
that can all be done with macros, but their coding is specific to each
instance..........

hth
Vaya con Dios,
Chuck, CABGx3

 

[R2D2]

Thank you all very much.