# Sickness tracker with a rolling 12 months

1. ## Sickness tracker with a rolling 12 months

Hi!
I have this spreadsheet which lists occasions of absence, and I'm trying to add a formula into Column G, which looks how many absences the employee has had in
the 12 months before the date of the current absence(given in Column D)? eg cell G10 would return the value 2, but cell G2 would return the value 1. Any ideas?
Thanks!
Sophie

2. ## Sickness tracker with a rolling 12 months

Hi everyone!
I have this spreadsheet which lists occasions of absence, and I'm trying to add a formula into Column G, which looks how many absences the employee has had in
the 12 months before the date of the current absence(given in Column D)? eg cell G10 would return the value 2, but cell G2 would return the value 1. Any ideas?
Thanks!
Sophie

3. ## Re: Sickness tracker with a rolling 12 months

Hi!

put this on G2:

Formula:
`Please Login or Register  to view this content.`

Pro Tip, Put this on F2:

Formula:
`Please Login or Register  to view this content.`

<3

4. ## Re: Sickness tracker with a rolling 12 months

Thank you! And thanks for the tip on calculating the working days!

Do you know what formula can be used so that any absences older than 12 months are excluded?
I've updated the spreadsheet with an example of what I'm trying to explain, hopefully it makes sense!
Edit: the additional row has the wrong date in - should be 2020 so that there is more than 12 months between the new absence and older periods of absence

Thanks!

5. ## Re: Sickness tracker with a rolling 12 months

Try this in G2, dragged down:
Formula:
`Please Login or Register  to view this content.`

Does that give you what you expect?

6. ## Re: Sickness tracker with a rolling 12 months

Hello Aardigspook

Yes that's great - thank you!!

Sophie

7. ## Re: Sickness tracker with a rolling 12 months

You're welcome, glad we could help and thanks for marking the thread as Solved.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1