View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MCMIS MCMIS is offline
external usenet poster
 
Posts: 1
Default Calculating # Days in a Date Range

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?