Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do this
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/06 to 2/3/06 1/10/06 to 2/10/06 etc or are we looking at a date format of dd mm yyyy In the top cell of your DATE column, type in the first date of the range of interest, such as 1/1/2005...........then, assuming that is in cell A5, in the cell just below it, put =A5+1, and copy the formula down as far as you want. Then, whenever you change the date in A5, the other cells will automatically follow.......... hth Vaya con Dios, Chuck, CABGx3 " wrote: col a (a7:a64) contains dates for the current month with data in subsequent columns data is pretty static (repetitious) from month to month at the end of each month i copy the current w/s to a new w/s (not w/b) is there an easy way just to change just the month in column a 1/15/06 becomes 2/15/06 thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i do this
=DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|