How to delete cells based on dates?

Hi,

Hope all are well.

Need a help using VBA in attached file.

In sheet PR Availability, Column C turns to Not Available based on various conditions. 1 of them is if column E is selected as "Out Of Office".

My requirement is as below.

When dates are entered in column F and G, column E should turn to Out Of Office within those dates.

For example, row 10 has dates 01.06.2023 to 02.06.2023. So Out Of Office shall be displayed from 01.06.2023 12.00 AM such that column C should show as "Not Available" and should disappear on 03.06.2023 12.00AM such that column C should be back to Available.

Note: CF in column C should work as usual.

Sheets, workbook and VBA will be locked with pass Gsk@123.


A bit tricky but can someone please help