If formula with dates
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
|