IF DAY and MONTH fall between 2 dates then....

Help please.....

I need an IF formulae to provide a true statement if the 25th-31st December falls between 2 dates (in 2 separate cells) regardless of the year (to remain dynamic)

I have attached a spreadsheet that hopefully provides further clarification

I think your date in D6 should relate to the year 2022, in which case you can use this formula in cell E5:

=AND(DATE(YEAR(C5),12,25)>=C5,DATE(YEAR(C5),12,31)<=D5)

then copy down.

Hope this helps.

Pete

Sorry guys, I had my question slightly wrong.....

I need the IF to return true if either of the below dates fall in the date range:
- 25th Dec
- 26th Dec
- 27th Dec
- 28th Dec
- 29th Dec
- 30th Dec
- 31st Dec

And I also apologise for the typo in the example, D5 should be 15/01/22

Sorry guys, I had my question slightly wrong.....

I need the IF to return true if either of the below dates fall in the date range:
- 25th Dec
- 26th Dec
- 27th Dec
- 28th Dec
- 29th Dec
- 30th Dec
- 31st Dec

And I also apologise for the typo in the example, D5 should be 15/01/22

I have tested both formula's against some other test data and it doesnt seem to be working on any......... I have attached said sample data

Thank you for your help thus far

Its still not entirely clear, but
=OR(AND(C13>=DATE(YEAR(C13),12,25),C13<=DATE(YEAR(C13),12,31)),AND(D13>=DATE(YEAR(D13),12,25),D13<=DATE(YEAR(D13),12,31)))

might work although a range of 12/12/2019 to 12/01/2020 woudl return false and the answer is probably true, but if your ranges dont span years that is not a problem
=IF(YEAR(C4)<>YEAR(D4),TRUE,OR(AND(C4>=DATE(YEAR(C4),12,25),C4<=DATE(YEAR(C4),12,31)),AND(D4>=DATE(YEAR(D4),12,25),D4<=DATE(YEAR(D4),12,31))))

might overcome that

Davsth......... both work perfectly. Thank you very much