I now have it sort of working with this formula:

=IF(AND(L7<(A1)-L760),"Pending",IF(AND(L7(A1)-L7<180),"FollowUp",IF(L7=(A1),"Completed",0)))

My problem now is that it isn't calculating the dates correctly it is
showing all cells as being "pending" (i.e. when I put in the date 1/2/2006 it
is still showing as "pending" instead of "completed").

I also would like to see if I could use the "stop light" coloring with this
as well and have yellow for the pending section, red for followup and green
for completed, if possible.
--
Thanks for everyone's help!
Shelly


"Pete_UK" wrote:

Have you missed one of the quotes off? Have you typed TODAY correctly,
and ensured there is no space after it and the open bracket?

Hope this helps.

Pete

On Dec 18, 3:05 pm, Shelly wrote:
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- Hide quoted text -

- Show quoted text -