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")
Let me know if you need more information.
- Erika
Bookmarks