Return "YES" or "NO" if a date in one worksheet is between two dates in another worksheet

Welcome to the forum.

I suggest you post a sample workbook instead of pictures.

Also can you not create a "Day Off" dataset that is standardized instead of the more difficult to manage layout you displayed in the bottom picture?

Thank you! I have attached a smaller sample workbook (at least I tried to attach it - not sure if it will work). Also, I defined a name "DaysOff" for the area where the dates for the days off will be entered. Is that what you meant by making it standardized? The formula now reads =IF(AND(DaysOff>=B2,DaysOff<=C2),"YES","NO") If that's not what you meant

Rotation Sample.xlsx

eleonardo1213, Welcome to the forum. Like mikeTRON indicates we really need a workbook.

You may be encountering a new interface for uploading files.

After clicking "Go Advanced" scroll down until you find "Manage Attachments". Click on that.

The dialogue window appears. Click "Browse".

Select your file.

Click "Upload"

and then click "Close Window" (yes I know that's counter-intuitive.)

You will be back at the "Manage Attachments" with nothing showing. Your file is there believe it or not.

Click "Post reply".

You'll see the icon for your file upon posting.

Try array-entering this in I2 and filling down.

Formula:

=IF(SUM((INDEX('Days Off'!$A$3:$Q$30,N(IF(1,ROW($1:$28))),N(IF(1,MATCH(D2:G2,'Days Off'!$A$2:$Q$2,0))))>=B2)*(INDEX('Days Off'!$A$3:$Q$30,N(IF(1,ROW($1:$28))),N(IF(1,MATCH(D2:G2,'Days Off'!$A$2:$Q$2,0))))<=C2)),"Yes","No")

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

PS I changed some dates to test this a little.