| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rolling year attendance
I am trying to set up an attendance sheet in Excel that will keep a total of
the days missed but subtract the days missed after a rolling year. I am using column A for the date, column B for the number of days missed (typically just a 1 or .5 for each particular date) and column C for the total days missed. I am sure it has to do with the SUMPRODUCT function, but I am having a hard time figuring it out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rolling Year | Excel Discussion (Misc queries) | |||
| rolling twelvemnoths formula for attendance calendar | Excel Worksheet Functions | |||
| Need to create attendance tracking based on % and 2080 hours/year | Excel Discussion (Misc queries) | |||
| Rolling year | Excel Discussion (Misc queries) | |||
| Rolling Year in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
