how do i do this - increment month by 1

i have 12 worksheets, 1 for each month

column a has dates
03/10/06
03/10/06
03/10/06
03/10/06
03/10/06
03/14/06
03/14/06
03/17/06
03/15/06
03/20/06
03/20/06
03/21/06
03/21/06
03/23/06
etc for march

i copy march ss to month 4, april

how do i pop the month up by one instead of going though each cell and
change the 03 to 04

day and year remain the same

tia

This may not be the best of answers but try adding another blank sheet and
copying your list of dates to Column A. In B1 enter the formula:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

and copy down the length of your dates using the fill handle. With the
formulas still highlighted, copy the range across as required. Again with
the fomulas still highlighted, copy the formulas and paste back into the
same range with Paste Special > Values.

Now use this table of dates to copy and paste to your various sheets.


--
HTH

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

<GeneralNuisance@Rme.net> wrote in message
news:bmjo225oeok4letqmt8q0t690jn1q505bb@4ax.com...
>i have 12 worksheets, 1 for each month
>
> column a has dates
> 03/10/06
> 03/10/06
> 03/10/06
> 03/10/06
> 03/10/06
> 03/14/06
> 03/14/06
> 03/17/06
> 03/15/06
> 03/20/06
> 03/20/06
> 03/21/06
> 03/21/06
> 03/23/06
> etc for march
>
> i copy march ss to month 4, april
>
> how do i pop the month up by one instead of going though each cell and
> change the 03 to 04
>
> day and year remain the same
>
> tia