Holidays in Cell Next to Day on Calendar

Hello,

How can the Holidays be in the cell next to the days like I put in cell I9 for Labor Day? These come from the Holidays sheet.

Thank you for your help

Hello Bob,

Since you have the date in F3 you can do a simple xlookup, or Vlookup:

Here is solution with Xlookup, paste this first in G3 and then copy from there to the other cells you want it.

Formula:

Please Login or Register  to view this content.

Thank you so much guys very good help.

Cheers!