Creating Date Field in Excel

A

Anonymous

let's say i want to A1 cell to have today's date
A2 cell tro have tomorrow's date and so on.
but i don't want to enter the dates by hand. is there a way to do
it automatically.?
I tried selecting the first column adn do format cells and select date
format but nothing appeared..


thanks a lot in advance for all the responses.
 
B

Bob Phillips

Yes,

A1: =TODAY()
A2: =A1+1
A3: =A2+1

etc.

That will update each day. If you want them static, in A1, hit Ctrl-:
(colon), and then just drag A1 down the other cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
K

Kevin Stecyk

Anon,

A1=today() (you can copy paste special values this cell if you want the
date to remain unchanged.)
A2=A1+1
Copy A2 down as many rows as desired. Format cells to your liking.

Regards,
Kevin
 
E

Edward

You can place a date in a cell and then with your cursor, drag the small
black square
sign at the bottom right corner of the highlighted date and drag down. The
dates will be inserted in order.

Hope this helps,

Ed
 
A

Anonymous

thanks, exactly what i was looking for.
You can place a date in a cell and then with your cursor, drag the
small black square
sign at the bottom right corner of the highlighted date and drag
down. The dates will be inserted in order.

Hope this helps,

Ed
Click to expand...
 
Top