Date Formula
How would a formula be written to add a defined number of months but not by
days, like [date in cell]A1+3 (months) instead of [date in cell]A1+90
(days, which is the default way Excel deals with dates)?
I have a spreadsheet that has quarterly maintenance that can be performed
anytime in January, April, July, and October, but it must be performed in
those months specifically. If I set up the formula as =[date in cell]A1+90
for the next quarterly maintenance due, the month will change depending on
how many days in the months of the quarter and when in the month maintenance
was performed.
Cell A1 date entered = 1/1/07
Cell A2 formula is =A1+90, Cell A2 value is Apr-07 ¦ which is correct,
according to the desired schedule. However¦
Cell A2 date entered = 1/31/07
Cell A2 formula is =A1+90, Cell A2 value is May-07 ¦ which is incorrect;
maintenance should be performed consistently in April.
Also,
Cell A2 date entered = 4/1/07, Cell A2 formula is =A1+90, Cell A2 value is
Jun-07 ¦ which is incorrect; maintenance should be performed consistently
in July.
I hope that I am explaining myself correctly - ANY help would be greatly
appreciated, Karen
|