My employer uses a scoring system to give a value to an individual’s sick record in the current rolling year.

Each person, has recorded, the number of sickness occasions and the total number of days in this rolling year period, these details go onto the final sheet where a score is calculated.

At present to get an accurate period, I have needed manually to deduct days to produce the correct time frame, ie 27/3/06 to 28/3/07 or when the sikness carrys on into the folling month.

I have tried without success to modify the rolling year formula, which as it is, will include the whole of March 06.

The formula is

=SUMIF(B5:D49,">="&DATE(YEAR(TODAY()),MONTH(TODAY())-12,1),L5:L49)

I am new to all this, but what I am trying to get is a current rolling year based around TODAY that will give values for total days and number of occasions without removing expired sick.

Each person, has recorded, the number of sickness occasions and the total number of days in this rolling year period, these details go onto the final sheet where a score is calculated.

At present to get an accurate period, I have needed manually to deduct days to produce the correct time frame, ie 27/3/06 to 28/3/07 or when the sikness carrys on into the folling month.

I have tried without success to modify the rolling year formula, which as it is, will include the whole of March 06.

The formula is

=SUMIF(B5:D49,">="&DATE(YEAR(TODAY()),MONTH(TODAY())-12,1),L5:L49)

I am new to all this, but what I am trying to get is a current rolling year based around TODAY that will give values for total days and number of occasions without removing expired sick.

## Comment