• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Fill in dates in Excel

Please teach me the fastest way to do the following:
1) In the top cell of a column place the current date(that will not over time later on)
2) fill out each of the cells below for N times by incrementing the date by 1. For example:
2/25/200011
2/26/200011
2/27/200011
...
12/30/2011
12/31/2011
Thanks,
0
ksfok
Asked:
ksfok
  • 2
1 Solution
 
roger_karamCommented:
A1 - type in todays date so it will not change  or use the formula "=today() " . This will update every day. You could use =today() then copy it and paste special -> paste as value in case you don't remember the day.

A2 - use the formula "=A1+1". Copy A2 and paste from A3 to however many dates you need.


Make sure you format the cells as date.


-RK
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

I understand you do not want the date in the first cell to change, so it's better not to use =today()

Instead, click the first cell, then hold down the Ctrl key and enter a ; sign (a semicolon). This will enter today's date as a constant that does not change when you open the file tomorrow.

Now, drag the fill handle of the cell (it's a little black square at the lower right corner of the cell) down the column. The dates in each cell will be incremented by 1 day.

See screenshot taken before and during the dragging.

 If you want to copy the date instead of incrementing, hold the Ctrl key while dragging down.

cheers, teylyn   before drag dragdown
0
 
roger_karamCommented:
Totally didn't know you could do that. Thanks Teylyn.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now