autodate

[bohon79]

Hello,

I have a sheet with multiple columns with data in it. in one column(lets say a2) I have a text (USMC, usaf, usa, usn), then in another column have a date (lets say b2). trying to get a future date (lets say c2), (30, 60 or 90 days later) in another column (lets say d2) if the text in a2 equals one of those text.

the reason is there will be different dates for each one.

thanks

 

[oldbrewer]

so A2 = usa and B2 = 13/4/18
what do you want in C2

 

[bohon79]

to have a future date in c2 based off of A2/b2

 

[Joe4]

I am not quite clear on the correlation between d2 and a2.
Do you only want the future date if d2=a2?
And how it is determined how many days to add to the date in b2 (you said 30,60,90 - so how do we know which one we should be using)?

 

[bohon79]

so basically if

a2=USMC
b2 has a date of 12 may 18
c2 would have a date of 12 jun 18 (30 days later)

or

a2=usa
b2 has a date of 12 may 18
c2 would have a date of 12 aug 18 (90 days later)

 

[Joe4]

In C2:
=B2 + IF(A2="USMC",30,IF(A2="usa",90,0)