# Solved: Excel 2007 Help with Dates

Discussion in 'Business Applications' started by irvinbang, Jun 18, 2013.

Not open for further replies.

Joined:
Jan 25, 2013
Messages:
85
I have attached the example document.

Would like to know if i entered in a known date, how would i have it add in a known remaining years.
if the years calculate by a point and not a month.

Ex. there are 12 years in a month. there are only 10 whole numbers in the calculation.

so if the computer gives me a remaining life of 2.5 years that would mean two years and 6 months.

but what if the computer gives me 2.2 remaining years? how many years and months is that?

And once the 2.2 is figured out how can i have it auto calculate that to the known date that i have to give
me a total date with the computer date and the know date?

Let me know if the example is not explained well enough.

#### Attached Files:

• ###### Book2.xlsx
File size:
10.9 KB
Views:
27

Joined:
Jun 27, 2003
Messages:
4,042
You don't need your chart to figure out the decimals. Probably the easiest way to do it is:

=B22+365.25*C2

This multiplies 365.25 (the average number of days in a year) times your half life to get the total number of days represented by the half life. Then add that to your date. It may be off by a day or two (depending on the half life) since some years have 365 days and some have 366, but it should be very close. Hope that helps.

Joined:
Jan 25, 2013
Messages:
85
Very nice i was over Thinking it!

Joined:
Jun 27, 2003
Messages:
4,042

As Seen On