I need a formula that will calculate the next review date based on the original date plus 180 days. The next review date is always going to the first day of a month regardless if the orginal date was on the 12th or 28th as an example. The problem I have is the original date can be from 3 to 6 years ago, each one is different. This spreadsheet is used once a month on the first day.
I have cell C3 set for the user to put in the first day of the particular month they are working on. I beleive this has to be part of the formula some way or form.
Column B contains the original date of the document needing to be reviewed. Column C is where I want it to calucate the next review date based on the above mentioned condition of 180 days from the original date. Here is what I want column C to look like with the new formula.
Original Date = 5-18-09 next review date = 11-1-10
Original Date = 6-29-09 next reveiw date = 12-1-10
Original Date = 5-27-10 next reveiw date = 11-1-10
The next review dates will have to stay the same each month until the date exceeds what is in C3 then it will need to calucate the next 180 reveiw date.
Thank you in advance for your consideration.
I have cell C3 set for the user to put in the first day of the particular month they are working on. I beleive this has to be part of the formula some way or form.
Column B contains the original date of the document needing to be reviewed. Column C is where I want it to calucate the next review date based on the above mentioned condition of 180 days from the original date. Here is what I want column C to look like with the new formula.
Original Date = 5-18-09 next review date = 11-1-10
Original Date = 6-29-09 next reveiw date = 12-1-10
Original Date = 5-27-10 next reveiw date = 11-1-10
The next review dates will have to stay the same each month until the date exceeds what is in C3 then it will need to calucate the next 180 reveiw date.
Thank you in advance for your consideration.