drag.....

[Guest]

i have column in worksheet for date for eg
| 15/06/05
| 15/07/05
| 15/08/05
|
| now monthwise i want to drag the column. Is it possible?
|
| this is in date format, also one more column
| June 05
| July 05
| Aug 05
|
| The date will remain same
| Thanks in advance

 

[R.VENKATARAMAN]

is there not a format mmm-yy
why not use it

 

[Max]

Try this ..

Put in A1:A2 :
15-06-05
15-07-05

Then select A1:A2 and drag the fill handle down (the black "square" at the
bottom right-corner of cell A2) as far as required, which will return:

15-06-05
15-07-05
15-08-05
15-09-05
15-10-05
15-11-05
etc

Put in B1: =TEXT(A1,"mmm yy")
Copy B1 down as many rows as you have filled in col A

Col B will return the month & year for the dates in col A
in the format: mmm yy (i.e. Jun 05, Jul 05, Aug 05)

If you want the full month (i.e. June, July, August, etc)
to display in col B, put instead in B1:
=TEXT(A1,"mmmm yy")