D
Danny Boy
The formula below works just fine FOR ME. However, one of our work computers
does not have the analysis tool pack downloaded, and unfortunately the Office
XP Home Edition CD that is needed to download the tool pack seems to have
gone missing.
When I place this same formula on the computer missing the "analysis tool
pack" I get the "n/a!" error. On my computer the formula works just fine.
My quesiton is this? Is there a way of altering the formula below so that it
can work properly for the computer missing the analysis tool pack? I believe
that the piece of the formula which is causing the problem (and needing the
analysis tool pack), is the EDATE portion of the formula. So if there is a
way of doing the same thing, but not using the EDATE function, I would
appreciate some feedback.
=IF(M4="","",IF(P4="","",IF(TODAY()>EDATE(M4,3),"Notify Referral Source-Exit
Not completed","")))
Thank you in advance!
Dan
does not have the analysis tool pack downloaded, and unfortunately the Office
XP Home Edition CD that is needed to download the tool pack seems to have
gone missing.
When I place this same formula on the computer missing the "analysis tool
pack" I get the "n/a!" error. On my computer the formula works just fine.
My quesiton is this? Is there a way of altering the formula below so that it
can work properly for the computer missing the analysis tool pack? I believe
that the piece of the formula which is causing the problem (and needing the
analysis tool pack), is the EDATE portion of the formula. So if there is a
way of doing the same thing, but not using the EDATE function, I would
appreciate some feedback.
=IF(M4="","",IF(P4="","",IF(TODAY()>EDATE(M4,3),"Notify Referral Source-Exit
Not completed","")))
Thank you in advance!
Dan