Date Formula

[wlbamc]

I currently have a formula which gives me a date if a review is due in 3 or 12 months. I now need to add weeks to the formula as well.

My formula currently is

=IF(I2<>"",EDATE(I2,MAX(K2:L2:M2)),"")

I am adding a column N and this needs to give me a date for 2 weeks after the date in column I, but I also need to keep the formula for the other columns as well.

Any help gratefully received

 

[jasonb75]

=IF(I2="","",I2+14)

 

[Snakehips]

I'm confused by a duplicate question having being raised today (now locked), yet this is marked as having been solved yesterday?

Here is what I was about to post on the locked post.

It actually incorporates @jasonb75 's formula of above.

=IF(I3<>"",IF(M3=2,I3+14,EDATE(I3,MAX(K3:L3:N3))),"")

Hope that helps

 

[wlbamc]

I'm confused by a duplicate question having being raised today (now locked), yet this is marked as having been solved yesterday?

Here is what I was about to post on the locked post.

It actually incorporates @jasonb75 's formula of above.

=IF(I3<>"",IF(M3=2,I3+14,EDATE(I3,MAX(K3:L3:N3))),"")

Hope that helps

Many thanks, works perfectly