I have attached an excel file (dattest1)
Col B contains Paid Leave dates for the factory (max 4 days in a month not exceeding 12 days in a year).
Col D contains calender days.
The formula in col F checks whether the date is a paid leave ("Yes") or not ("No"). The formula is somewhat lengthy and I
feel this could be simplified further.
I have tried to simplify (formula in col E) but the results are incorrect.
I request the experts to suggest whether the simplification of the formula in col F is possible.
Bookmarks