software

On Thu, 12 Jan 2006 07:17:01 -0800, in
microsoft.public.excel.worksheet.functions you wrote:

i'm not sure i understand your logic
a 1 increments my date by one (1) DAY
adding 30 increments by 30 days which doesn't quite work because of
months ending in 28,30 and 31 days

what i am really after is something will change

1/3/06to2/3/06
1/10/06to2/10/06
etc

or are we looking at a date format of dd mm yyyygt; gt; In the top cell of your DATE column, type in the first date of the range of
gt; gt; interest, such as 1/1/2005...........then, assuming that is in cell A5, in
gt; gt; the cell just below it, put =A5 1, and copy the formula down as far as you
gt; gt; want. Then, whenever you change the date in A5, the other cells will
gt; gt; automatically follow..........
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot; wrote:
gt; gt;
gt; gt; gt; col a (a7:a64) contains dates for the current month with data in
gt; gt; gt; subsequent columns
gt; gt; gt;
gt; gt; gt; data is pretty static (repetitious) from month to month
gt; gt; gt;
gt; gt; gt; at the end of each month i copy the current w/s to a new w/s (not w/b)
gt; gt; gt; is there an easy way just to change just the month in column a
gt; gt; gt;
gt; gt; gt; 1/15/06 becomes 2/15/06
gt; gt; gt;
gt; gt; gt; thanks
gt; gt; gt;
gt; gt; gt;

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

HTH
Kostis Vezerides