Calculating # Days in a Date Range

[MCMIS]

HELP! I am trying to track the number of times employees have unexcused absences in a 90-day period. I have a spreadsheet where the date of the absence is input. What I need to do is create a formula/code to calculate if an employee has three or more incidents in a 90-day period. If so, I need a visual flag to appear in another cell.

Does anyone have any ideas how to calculate this with the visual flag?

 

[Bernie Deitrick]

How is your data organized? Are you simply inputting dates of
absences into a row of cells? Or do you have Dates as headers and put
"Absent" into a cell?

We need a better explanation to help you.

Bernie
MS Excel MVP

HELP! I am trying to track the number of times employees have

unexcused absences in a 90-day period. I have a spreadsheet where the
date of the absence is input. What I need to do is create a
formula/code to calculate if an employee has three or more incidents
in a 90-day period. If so, I need a visual flag to appear in another
cell.

Does anyone have any ideas how to calculate this with the visual

flag?