Fill date series

J

Jessica

Hello,

How could I use the "fill series" to make my dates appear like this:

12/08, 11/08, 10/08, 9/08, 8/08, 7/08.......

I want to go backwards in time, left to right.

Thank you!
 
S

Sheeloo

Enter 12/8 in A1 and 11/8 in B1
Select A1 and B1
Drag the right-bottom corner of B1 to right...

I tested with Excel 2007
 
J

Jessica

Thank you that worked!!


Sheeloo said:
Enter 12/8 in A1 and 11/8 in B1
Select A1 and B1
Drag the right-bottom corner of B1 to right...

I tested with Excel 2007
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find within Date Range 4
Find Period Date? 5
Date Axis 5
Variable Dates in Graph Scale 1
XIRR 3
macro help 1
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
Date Difference 2

Top