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.
If i have a number, like 3 in a cell, then a want a particular formula for occur for three years, if if have a 4 in a particular cell i would like another particular formula to occur in this cell. How do I do this?
Jim
As variant you may use IF() or CHOOSE() or like, but depends on what exactly do you mean.