Hi, I need a code that will enter a date in Column I that is 6 months from the date in Column C if you type "Y" in Column H. All dates are in dd/mm/yyyy format. The date result in Column I needs to fall on a workday (M-F non-holidays). E.g., if 6 months from the date in Column G is a Sunday, the date in Column I will be Monday. I have a separate sheet in the same workbook where I've defined the column listing all the holidays as "HOLIDAYS."

The code will pertain to Sheet1 which is named "OpenCases." NOTE: Sheet1 already has a code that automatically moves the entire row when you enter "Closed" in Column F.

P.S. - I'm trying to attach a sample workbook but am experiencing issues!

THANK YOU!!!