Calculating # Days in a Date Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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

MCMIS said:
HELP! I am trying to track the number of times employees have
Click to expand...
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
Click to expand...
flag?
 
Back
Top