Formula needed for future date using variable text from 1 column and dates from another.

Hi folks,

I currently have a formula in column I...

=IF(H2="","",IF(H2="N/A","N/A",DATE(YEAR(H2),MONTH(H2),DAY(H2)+7)))

...which works great, however I now need to vary +7 to +14 depending on what I have in column B, whilst still maintaining the reference to the date in column H.

I'm a complete novice and can't figure out how the formula should be written to add +7days from the date in column H if column B reads Priority and +14 from the date in column H if column B reads Standard.

Any help would be greatly appreciated as I can't seem to find a solution elsewhere on the forum, though I'm sure there is probably an answer there already for it, I just can't find the right terminology to pinpoint it.

Wow fantastically fast response nflsales and works perfect.

Thanks a million.

Thanks rajansettu also, your solution works perfect too. I'm now spoiled for choice.

Excelforum rocks!