drag.....

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

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")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ankur" <Ankur@discussions.microsoft.com> wrote in message
news:84393B7E-A409-4B21-B90F-CE026663DAE9@microsoft.com...
> 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
>
>
>

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


Ankur <Ankur@discussions.microsoft.com> wrote in message
news:84393B7E-A409-4B21-B90F-CE026663DAE9@microsoft.com...
> 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
>
>
>