Adding days to an existing date and formatting

[Anonymous]

Hello my Qlik friends around the world.  I am trying to re-write an existing Excel formula to use in a Load statement in QlikView.  Here is the Excel formula:

=IF(F2="85DAYPEND",D2+85,

IF(F2="FINATMPT",D2+30, IF(F2="ATMPTPLUS",D2+30,

IF(F2="NEEDATPYPL",D2+30,

IF(OR(F2="ATTEMPT1",F2="NEEDATPT2"),D2+300,

IF(OR(F2="ATTEMPT2",F2="NEEDATPT3"),D2+270,

IF(OR(F2="ATTEMPT3",F2="NEEDATPT4"),D2+240,

IF(OR(F2="ATTEMPT4",F2="NEEDATPT5"),D2+210,

IF(OR(F2="ATTEMPT5",F2="NEEDATPT6"),D2+180,

IF(OR(F2="ATTEMPT6",F2="NEEDATPT7"),D2+150,

IF(OR(F2="ATTEMPT7",F2="NEEDATPT8"),D2+120,

IF(OR(F2="ATTEMPT8",F2="NEEDATPT9"),D2+90,

IF(F2="ATTEMPT9",D2+60,"")))))))))))))

I am having trouble with the "D2" portion of the formula.  The "D2" value is a cell with a date value in it, formatted as yyyy-mm-dd.  I need to add, for example 85 days to the existing date if the value in cell F2 is equal to "85DAYPEND".  I would truly appreciate some help with this formula.  Thank you everyone