Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Column of dates

Status
Not open for further replies.
Klae

Klae

Programmer
Mar 5, 2001
269
GB
Hi,

I have a user who wants Column A to list dates from Apr-01 to 4 years ahead I.E. apr-05. how can I do this without manually entering the month in each cell downwards in Column A?

TIA Klae{/color]

You're only as good as your last answer!
 
Sort by date Sort by votes
Type Apr-01 in cell A1, click in the bottom right hand corner of A1 then drag down until it displays Apr-05, let go and it's done.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
196
SkipVought
S
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
166
Andrzejek
Andrzejek
titanif
  • Locked
  • Question
Office 365- Spill A Table Column Into Another Tables Column
Replies
1
Views
134
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365 (2016) Working to auto-populate dates 3
Replies
13
Views
270
ladyck3
ladyck3
bhujanga
  • Locked
  • Question
Prevent Converstion of Long Numeric Strings to Exponential Format 1
Replies
4
Views
198
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top