Inserting a date field

R

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.
 
P

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
 
G

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
 
C

CLR

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
 
Top