Forum Discussion
Solved
Month is true, when it it between a date range.
Hi, I want the Month to be true. If one or more dates in a date range is in that month. Please see excample file for details. Best Regards - Geir
In G8:
=IF(AND($E8<=G$4,$F8>=G$3),"T","F")
Fill to the right, then down or vice versa.
In G8:
=IF(AND($E8<=G$4,$F8>=G$3),"T","F")
Fill to the right, then down or vice versa.
Thank you, it worked perfect.
- Geir
- Geir