Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula with dates
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula with dates
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula with dates
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Dates | Excel Discussion (Misc queries) | |||
Sum If formula for between dates | Excel Discussion (Misc queries) | |||
Help with Dates in a Formula | Excel Worksheet Functions | |||
Need a Formula for DATES | Excel Worksheet Functions | |||
Dates in Formula | Excel Discussion (Misc queries) |