Solved Excel formula to add dates

August 3, 2011 at 00:33:46
Specs: Windows XP
how do i write a formula for this. if priority high add 2 days to date raised, if priority low add 14 days to date raised?

See More: Excel formula to add dates

Report •


#1
August 3, 2011 at 06:36:33
What do you mean by "date raised"?

How will Excel know what is a High priority and what is Low?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 3, 2011 at 15:44:24
hi, am setting up a housekeeping spread sheet. date raised is when issue found eg 4/08/2011, i have enougther column set with priority high medium low, they have values on 2 ,7, 14 days to have issue fixed in drop down box. would like the formula to set date using words high etc

Report •

#3
August 3, 2011 at 16:25:13
✔ Best Answer
With your date in A1 and your High, Medium, Low drop down in B1, use this:

=IF(B1="High", A1+2, IF(B1="Medium", A1+7, A1+14))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question