Forum Discussion
Solved
Formula with Date Ranges
I would like for an "X" to appear in a cell when certain date ranges are entered in another cell. I currently have a formula for the X to appear when the date range 10/19/2020 - 10/25/2020 is ent...
Try this one:
=IF(OR(AND(A1>=DATEVALUE("10/19/2020"), A1<=DATEVALUE("10/25/2020")), AND(A1>=DATEVALUE("11/01/2020"), A1<=DATEVALUE("11/06/2020"))),"x","")- You may extend the formula for more dates.
- Adjust dates & cell references in the formula as needed.
Rajesh_Sinha Thank you this answer did work.
Now I need to figure out how the formula for when multiple different date ranges produce different responses.
Example:
I want for the date range of 10/19/2020 - 10/25/2020 to produce 11 in one cell.
And when the date range is 10/26/2020 - 11/01/2020, I want it to produce 18 in the cell.
Then when the date range is 11/02/2020 - 11/08/2020, I want it to produce 25 in the cell.
Can you help me with this?
Glad to help you,,, keep asking ☺