OP is attempting to apply TREND/FORECAST to an attendance tracking mission. I know how those functions work. I do not always know how to apply them in sound ways.

Anyone want to take a crack at this?

Attempting to Predict Future Employee Attendance Occurrences

In case it helps the thread also contains a link back to another thread where this all started.