VBA to place text label resulting from condition.

[ericv101]

In the attached example, I would like to have VBA code that automatically runs on cell value changes in the "End" column of the "Date Ranges" area to place a text label or "Flag" column beginning with cell E10. This "flag" (D/F) should be the result of the date (column C) falling between (to include start and end dates) of any of the date ranges input in the "Date Ranges" area.

Please ignore "Test Flag 1.xlsx" as I've added Before and After tabs to the "Test Flag 2.xlsx" file to make the desired results more apparent.

Thank you in advance for any assistance you are able to provide!

[nilem]

Hi ericv101,
maybe this (in 'E10' cell)

Please Login or Register  to view this content.

[ericv101]

Hi Nilem -

The formula you've provided works beautifully within the spreadsheet I attached. I should have been more clear about the number date ranges as there could be many individual start / end date pairs. I believe it will require a looping function but that is a bit beyond my ability at the moment. Thanks again for you help!

-Ericv101