Formula Needed to Populate a Next Date

[crizzo]

I require some help with a logic formula to populate the next date for an assessment schedule.

I have 3 columns.

Column A contains a frequency: "annual" biannual" or "N/A"
Column B contains a 4 digit year: 2014, 2015, 2016 etc
Column C needs to contain a formula to populate what the "next" date will be based on the year from column B and the frequency contained in column A. (ie. If a is "annual" and b is "2015" then c will display "2016"; if a is "biannual", b is "2015" then c will display "2017"; if a is "N/A" and b is "N/A" then c needs to populate "N/A"

I can do a basic formula, but it doesn't work the way I want it to. It's populating a "1" or "2" rather than an N/A.

Any help would be much appreciated.

Thanks,

Crystal

 

[Joe4]

Welcome to the Board!

Is this what you are looking for?

=IF(A1="annual",B1+1,IF(A1="biannual",B1+2,"N/A"))

 

[crizzo]

Thank you SO much! Very appreciated

Cheers,

C

 

[Joe4]

You are welcome. Glad to help!