Check if range of dates fall between two dates

Hello everyone,

I'm trying a couple of days to solve an issue with my formula and not getting it to the end.

So, basically what do I need: To check within a range of dates, if the date falls between two dates. If the result is positive, I want excel to write in the cell "Order", if not, leave it blank. As well taking another range in the same formula to check the dates and in case of positive result to write "Home".

Maximum what I figured out is the following formula:
=IF(OR($T$3>=AJ1;$T$3<=AK1;$V$3<=AJ1;$V$3>=AK1;$V$3<=AJ1;$X$3>=AK1;$X$3<=AJ1;$Z$3>=AK1;$Z$3<=AJ1;$AB$3>=AK1;$AB$3<=AJ1;$AD$3>=AK1;$AD$3<=AJ1;$AF$3>=AK1;$AF$3<=AJ1);"Order";IF(OR($U$3>=AJ1;$U$3<=AK1;$W$3>=AJ1;$W$3<=AK1;$Y$3>=AJ1;$Y$3<=AK1;$AA$3>=AJ1;$AA$3<=AK1;$AC$3>=AJ1;$AC$3<=AK1;$AE$3>=AJ1;$AE$3<=AK1;$AG$3>=AJ1;$AG$3<=AK1);"Home";" "))

You can check the picture attached.

Any suggestion is most welcome.

??????????.png

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.