Dates
Posted by Orlando on September 06, 2001 8:32 AM
Hello:
I am trying to write a formula or macro that will give me a Yes or No response to if a certain date falls in a range of dates.
Example 12/01/01 is in cell A1 12/12/01 is in cell B1
12/07/01 is in cell C1 how can I write a formula in cell d1 or a macro that would look at C1 and respond Y or N that the date in C1 falls in the range dates of A1-B1?
Please reply to my email address oriver58@aol.com
Thank you very, very much
Orlando
Posted by Aladin Akyurek on September 06, 2001 8:46 AM
=IF((C1>=A1)*(C1<=B1),"Yes","No")
Aladin
Posted by Windowless Will on September 06, 2001 8:54 AM
=IF(AND(C1>A1,C1<B1),"Yes","No")
Posted by Windowless Will on September 06, 2001 8:55 AM
Got cut off somehow
=IF(AND(C1>A1,C1<B1),"Yes","No")
Posted by Mark W. on September 06, 2001 8:58 AM
{=IF(PRODUCT(A1:B1-C1)<=0,"Y","N")}
Note: This is an array formula which must be
entered using the Control+Shift+Enter key
combination. The braces, {}, are not entered
by you -- they're supplied by Excel in
recognition of a properly entered array formula.
Posted by Mark W. on September 06, 2001 9:17 AM
Your posting difficulty...
Will, this bulletin board has some idiosyncrasies.
One being it doesn't like less than signs that
aren't immediately followed by a space. I believe
that it assumes that it's the beginning of a tag.
To circumvent this problem I'm in the habit of
always placing a space character before and after
a less than or greater than sign as follows:
=IF(AND(C1 > A1,C1 < B1),"Yes","No")
Posted by Aladin Akyurek on September 06, 2001 9:22 AM
A trick that I for one keep forgetting...Alas. (NT)
