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

1. ## 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.

2. ## Re: Formula needed for future date using variable text from 1 column and dates from anothe

=IF(ISNUMBER(H2),H2+IF(B2="Priority",7,IF(B2="Standard",14,0)),"")
Try this

3. ## Re: Formula needed for future date using variable text from 1 column and dates from anothe

hi,

try this,

``Please Login or Register  to view this content.``

4. ## Re: Formula needed for future date using variable text from 1 column and dates from anothe

Wow fantastically fast response nflsales and works perfect.

Thanks a million.

5. ## Re: Formula needed for future date using variable text from 1 column and dates from anothe

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

Excelforum rocks!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1