Rolling 365 attendance tracker

**LotusLL** · 04-16-2015, 04:02 AM

Our HR department are attempting to update the processes they use to make them more automated. They are asking primarily for a formula that can track sickness over a rolling 365 day block across two separate sheets.

I've attached a basic example spreadsheet, an attended day would be indicated in hours which are variable based on how many hours the operative has done. Authorized absence would be indicated by "H", Unauthorized absence by "U" and Sickness would be indicated by the letter "S".

If anyone has a similar formula or any advise, it would be greatly appreciated

**p24leclerc** · 04-16-2015, 05:12 PM

Try this formula and copy it down the column:

Please Login or Register  to view this content.

**FDibbins** · 04-16-2015, 05:33 PM

Hi, welcome to the forum

Would it be possible to put all your data into 1 sheet? And on top of that, to swap things around so the dates go downwards?

Im thinking that if you could do this, a relatively simple COUNTIFS() would work for you...

=countifs(date-range,"<="&TODAY(),date-range,">="&EDATE(TODAY(),-12)...................