I am working with an Excel Spreadsheet with a lot of dates. Attached is a sample file with a few example dates. The first Worksheet is called "Dates".
in Column A is the Begin Date and Column B is End Date.
Column C is Holiday. I need to verify if a Holiday occurs between the 2 dates. I don't need a Count of Holidays, just to return a value of "YES" or "1" if a Holiday occurs between the date range in each row. The spreadsheet has a second worksheet, called "Holidays" that I wanted to use as a lookup table. Any ideas on how this can be done with an Excel formula in Column C of the "Dates" worksheet? Thanks very much for any assistance.
Bookmarks