We are setting up an excel file to track absences (by date). Each person is
permitted from 1-6 absences within a rolling year. We need a formula to
determine if the number of absences allowed have exceeded those permitted
within a year timeframe. I have played with using macro to change date
format to general format and subtracting the 2nd or 6th cell (date) from the
first cell (date) and writing an "IF" condition for 365 days. This works for
the first entry or time we start keeping track of absences. But it does not
help us to drop these dates off if they are more than a year apart. Any
suggestions will be appreciated.