Date formula

[tylerf]

Good morning,

I am needing some help coming up with a formula. In A1 I have the date that a customer signed up to do business. In cell A2 is my variable, the number of months it took a customer to report. In cell A3 is where I need a formula that will give me the reporting date based on the start date taken out the number of months indicated in A2. Please see example below.

reporting date example.xlsx

Thanks in advance!

[Jonmo1]

Try

=EDATE(A2,B2)

[jeffreybrown]

Try...

=EDATE(A2,B2)

[tylerf]

thanks guys! that works great, and is really simple. I really aprpeciate it.

[jeffreybrown]

You're welcome...we are glad to have helped and thanks for the feedback...

http://www.excelfunctions.net/

[Jonmo1]

You're welcome.