Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions |