Excel Question

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have developed a excel sheet to help me with my work I
am new to excel and have only done some things. This is a
time sheet for inmates. I want each cell to calculate for
the next item.if I type in the sentence 5yrs 6 months to
serve then type in the date the sentence was received
...then how do I get it to automatically come up in the
Normal Maximum Expiration date to come up like this in
the yrs cell 2008 in the months cell 6 and the days cell
should be 3 day if my figures are correct..then in the
Credit for Jail time I enter 1 yr , 6 months 3 days.I
need the adjusted max date to figure automatically and so
on for each cell except for the education good time if
that is achieved by and inmate that is 60 days of there
sentence...Can you please help me with the formulas or
code to get this done..Here is the sheet from excel


Year Months Days
Total Time to serve 5 6
Date Sentence Received 2002 12 3
Normal Maximum Expiration Date 2008 6 3
Credit for Jail Time 1 6 3
Adjusted Max. Expiration Date ? ? ?
Good Time Allowance
Minimum Expiration Date
Educational Good Time Award
New Minimum Exp. Date
Meritorious Good Time Award
New Minimum Exp. Date
Work for Time Credit
New Minimum Exp. Date
 
I have developed a excel sheet to help me with my work I
am new to excel and have only done some things. This is a
time sheet for inmates. I want each cell to calculate for
the next item.if I type in the sentence 5yrs 6 months to
serve then type in the date the sentence was received
..then how do I get it to automatically come up in the
Normal Maximum Expiration date to come up like this in
the yrs cell 2008 in the months cell 6 and the days cell
should be 3 day if my figures are correct..then in the
Credit for Jail time I enter 1 yr , 6 months 3 days.I
need the adjusted max date to figure automatically and so
on for each cell except for the education good time if
that is achieved by and inmate that is 60 days of there
sentence...Can you please help me with the formulas or
code to get this done..Here is the sheet from excel


Year Months Days
Total Time to serve 5 6
Date Sentence Received 2002 12 3
Normal Maximum Expiration Date 2008 6 3
Credit for Jail Time 1 6 3
Adjusted Max. Expiration Date ? ? ?
Good Time Allowance
Minimum Expiration Date
Educational Good Time Award
New Minimum Exp. Date
Meritorious Good Time Award
New Minimum Exp. Date
Work for Time Credit
New Minimum Exp. Date
Click to expand...

Hi John,

Interesting project. I am not familiar with the detailed specifics, but
perhaps I can provide some food for thought.

1) Col A (Description) Col B (date) Col B (years)
Col C (months) Col D (days)
2) Year Months Days
3) Total Time to serve 5
6
4) Date Sentence Received 2002 12 3
5) Normal Max. Exp. Date =B4+365*B3+30*C3+D3
6) Credit for Jail Time
1 6 3
7) Adjusted Max. Exp. Date =B5-365*B6-30*C6-D6
8) Good Time Allow. and so on....
9) Minimum Exp. Date
10) Ed. Good Time Awd
11) New Min Exp. Date
and so on.

All I have done is create a "date" column, and columns for years, months,
and days. Then I just used those columns to calculate the dates. Be sure
to format Column B as "date" in the form that you like--yyyy-mmm-dd or
whatever. Just select Column B, right mouse click, format cells, date.

I hope that helps.

Best regards,
Kevin
 
Back
Top