You've presumably got a typo in the formula.
Don't try to retype the formula; copy it from here & paste into your
formula bar.
--
David Biddulph

"Shelly" wrote in message
...
This formula looks great, but when I put it in, I keep getting the #NAME?
error message; and I was incorrect, it was actually L8 instead of M8, but
even when I changed that, it still gave me the error.
--
Shelly


"Sheeloo" wrote:

If M8 has the date (assumed to be in the past) then try this
=IF((Today()-M8) < 60, "Pending",IF((Today()-M8) < 180,"Follow
Up","Completed"))

"Shelly" wrote:

I'm using Excel 2007; I am trying to write a conditional formula. What
I
essentially want is that if the date is less than 60 days I want the
status
to show pending, if the date is between 60 and 180 days I want to
follow up
with what I have to do and after 180 days, I would like it to show
completed
or something like that.
So far I have =IF(M860,"FOLLOWUP", IF(M8180,"OK")) excel won't let
me put
in more data, and when I've played with the dates I'm not too entirely
sure
if this works either.....
And my formula for the dates is fine, I'm just not sure what to do for
this
one.
--
Thank you!
Shelly