Year-Days-Months
Not sure you saw this, but...
One more small problem. E.g. , if the prior calcs resulted in 20 years, 14
months,I can figure out if months are = 12, to add a 1 to the years with
this formula
Year cell =IF(I4=12,H4+1,I4) &
Month cell =(IF(I4=12,I4-12,I4))
Yrs Months
H4 I4
20 14
21 2
This will work up to 24 months, but how could I get it to work for 24
months ?
Much appreciated,
Thanks,
Steve
"Roger Govier" wrote:
Hi Steve
You're very welcome, thanks for the feedback.
I wish my retirement were that far ahead!!!
--
Regards
Roger Govier
"Steve" wrote in message
...
Perfect !! Thanks so much. It came out to be an exact match of what I
needed.
Now with the today(), &/or various future dates manually entered,
your
formula will enable me to figure out when I'm going to retire. :)
Thanks again,
Steve
"Roger Govier" wrote:
Hi Steve
One way would be to create 2 absolute dates then use the Datedif
function.
Put a starting date of say 01/01/2000 in a cell - I used C8
In cell D8 enter
=C8+13346
Then use the following formula
=DATEDIF(C8,D8,"y") &" years "&DATEDIF(C8,D8,"ym")&" months
"&DATEDIF(C8,D8,"md")&"days"
which returned 36 years 6 months 15 days for me.
--
Regards
Roger Govier
"Steve" wrote in message
...
If I have 13346 days, I need to find out how many years, months &
days
that
represents. I got as far as 13346 / 365 = 36.56, so I could get the
years
with left,2, but I'm having trouble converting the .56 into a 30
day
month,
and the # of days remaining.
Any help would be greatly appreciated.
Thanks,
Steve
|