Using a Formula in Excel to create an "x" if date entered is between two dates
I am looking for a way to create a formula that will give me an "x" in a cell if one date falls between a certain quarter and the second date falls between another quarter.
The quarters are as follows:
Jan-Feb-Mar
April-May-June
July-Aug-Sept
Oct-Nov-Dec
For example: If the first date I enter is 2/13/13 and the second date I enter is in 5/24/13 which is the following quarter, I want an "X" to appear in a cell labeled "positive." If the first date is still 2/13/13 and the second date is 6/24/13 which is not in the following quarter, I want an "X" to appear in a cell labeled "negative."
Below is what I want it to look like:
Right now all I can get it to look like is this:
the formula that I have, for the table above is: =COUNTIFS(A2:B2,">=1/01/13",A2:B2,"<=5/30/13")
Any recommendations?
I am looking for a way to create a formula that will give me an "x" in a cell if one date falls between a certain quarter and the second date falls between another quarter.
The quarters are as follows:
Jan-Feb-Mar
April-May-June
July-Aug-Sept
Oct-Nov-Dec
For example: If the first date I enter is 2/13/13 and the second date I enter is in 5/24/13 which is the following quarter, I want an "X" to appear in a cell labeled "positive." If the first date is still 2/13/13 and the second date is 6/24/13 which is not in the following quarter, I want an "X" to appear in a cell labeled "negative."
Below is what I want it to look like:
Date Entered | Returned to Work | Positive | Negative |
2/13/2013 | 5/24/2013 | X | |
2/13/2013 | 6/24/2013 | X |
Right now all I can get it to look like is this:
Date Entered | Returned to Work | Positive | Negative |
2/13/2013 | 5/24/2013 | 2 | 0 |
2/13/2013 | 6/24/2013 | 1 | 1 |
the formula that I have, for the table above is: =COUNTIFS(A2:B2,">=1/01/13",A2:B2,"<=5/30/13")
Any recommendations?