Hi Mike:

thx for the quick response. It didn't work. When I enter the formula the
pop-up shows up saying "The formula you typed contains an error" and it
highlights the "Y" in the formula....

any ideas?
Thanks
Monika

"Mike H" wrote:

Hi,

Try this

=IF(ABS(TODAY()-A1)<=90,"Y","N")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"murkaboris" wrote:

Hello:

I need a formula that can look at column "A" and calculate the number of
days from today --- could be either before today or in the future and if it
is equaled to or less than 90 return "Y" otherwise "N"....

I keep getting "VALUE!" errors.
Please help.

Thank you.
Monika