I was wondering if someone can help me.
I have this formula
It is designed to count the Number of Calendar Days between the first Start Date (Column B) & the last End Date (Column C)
However I have another column, column D that has certain terms. E.g "Exempt" I want the formula to ignore rows/dates that have this term.
So if it says "Exempt" In B9 The start date should be B10 if it says "Exempt" in C15 the end Date should be C14.
Is it possible to achieve this?
Thanks for the help,