Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I count number of occurrences (dates) in a rolling year?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I count number of occurrences (dates) in a rolling year?
It should be possible with a formula.
How is the data structured, the dates and the identifier for absence. We should be able to get the max date for an absence and the date of the 6th ago absence if you see my meaning, and subtract 1 from the other, if less than 365, problem. -- HTH RP (remove nothere from the email address if mailing direct) "ShirleyTR" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating total number of days in rolling year | Excel Worksheet Functions | |||
Count occurrences of dates | New Users to Excel | |||
Count number of occurrences | Excel Discussion (Misc queries) | |||
Count Number of Occurrences in a Column | Excel Worksheet Functions | |||
Need to Count number of occurrences and get percentage of total | Excel Worksheet Functions |