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.
Bookmarks