=IF(M4="","",IF(P4="","",IF(TODAY()DATE(YEAR(M4), MONTH(M4)+3,DAY(M4)),"Notify
Referral Source-Exit Not completed","")))
--
David Biddulph

Danny Boy wrote:
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),"N otify Referral
Source-Exit Not completed","")))

Thank you in advance!

Dan