How to calculate release dates for prisoners?

[icecoldza]

I need a spreadsheet calculation where if a prisoner is sentenced today for a period of eg... 5 years 6 months it must give me the release date based on full sentence, 1/2 sentence 1/3,1/4 & 1/6 of his sentence period.

The 1/2 (Prisoner do only 1/2 of that sent.)
The 1/3 (Prisoner do only 1/3 of that sent.) ect.

Another problem is that sometimes the sentence is eg. 50 days or 6 months or 5 years 3 months ect.

Any help?

Thanks

 

[Legacy 21301]

A years term is defined as calendar year, civil year - the year according to Gregorian calendar.

Meaning a year is from a date of sentence to the next years same date.

365 or 366 on leap years.

The same goes for a months. In one month out the same day next month.

So what you really need to do is determine the total number of days sentenced then you can do you calcs.

That's what my suggesed formula does.

Note : "In one month out the same day next month" - If there is no such day in the next month then it must be pre-determined what day is to be set. This is where Fairwind's formula and my formula differ.
(The same applies for years if the start date happens to be 29 Feb.)

 

[fairwinds]

In one month out the same day next month.

Given that, I agree with Ponsys formula.

 

[destiny macumber]

My son is in south Carolina prison.he was sentenced to 5 yrs.his beginning date is 10/18/15.how long would he do? Does that include work credits also