If formula with dates

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

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

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

Hmm,

Is that my formula copied and pasted from the post or one you typed?

My fomula is correct for my region, copy and paste it into a cell.

What is the delimiter in your region. My area uses a , does yours use a semi
colon ;

If so change the 2 commas to semi colons
--
Mike

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


"murkaboris" wrote:

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

Hi Mike:

Not sure what it was, but the copy paste fixed it.
Thanks for your help!

Monika

"Mike H" wrote:

Hmm,

Is that my formula copied and pasted from the post or one you typed?

My fomula is correct for my region, copy and paste it into a cell.

What is the delimiter in your region. My area uses a , does yours use a semi
colon ;

If so change the 2 commas to semi colons
--
Mike

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


"murkaboris" wrote:

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