| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating # Days in a Date Range
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" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating 6 days from a date | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Calculating three working days before a date | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
