HI All,
I have two cells with a start date and end date e.g 01/05/21 to 01/07/21, this range can be small or it can span several years. I have another cell with a month i.e January.
What i would like is a formula that tells me if January (or another month) is within the date range, so for the dates 01/05/21 to 01/07/21 the answer would be no, but if the date range was 01/05/21 to 10/01/22 the answer would be yes as Jan is in the date range.
Can anyone help?
I have two cells with a start date and end date e.g 01/05/21 to 01/07/21, this range can be small or it can span several years. I have another cell with a month i.e January.
What i would like is a formula that tells me if January (or another month) is within the date range, so for the dates 01/05/21 to 01/07/21 the answer would be no, but if the date range was 01/05/21 to 10/01/22 the answer would be yes as Jan is in the date range.
Can anyone help?