Trying to auto populate a future date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some help. I am trying to do something I thought would be simple ... and am finding that it is above my knowledge base.

I am trying to automatically fill in cell C1. I know A1 and B1. A1 is the date of the last review and B1 is the frequency of reviews 1=monthly, 3=every other month, 6=every six months etc.

So for example if A1 was "June 1, 2004" and B1 was "7" I am trying to have C1 automatically tell me that the next review should be "January 1, 2005". It would look something like this:

A1= Last review B1=Frequency C1=Next review
June 1, 2004 7 January 1, 2005

If anyone can help I would appreciate it!
 
I need some help. I am trying to do something I thought would be simple ... and am finding that it is above my knowledge base.

I am trying to automatically fill in cell C1. I know A1 and B1. A1 is the date of the last review and B1 is the frequency of reviews 1=monthly, 3=every other month, 6=every six months etc.

So for example if A1 was "June 1, 2004" and B1 was "7" I am trying to have C1 automatically tell me that the next review should be "January 1, 2005". It would look something like this:

A1= Last review B1=Frequency C1=Next review
June 1, 2004 7 January 1, 2005

If anyone can help I would appreciate it!
Click to expand...


Try this in cell C1

=DATE(YEAR(A1);MONTH(A1)+B1;DAY(A1))

Hope this helps

larske
 
This did not work ... but it got me in the right area and I found EDATE fuction. By changing A1 to use the DATE function and C1 using the EDATE fuction it worked! So thank you!
 
Back
Top