Date calculation

You name the cell where you want to enter the start date "DATE", and the cell where you enter your end date (31/12/08, 31/12/09, or other) "FIN".

Your formulas will be =TODAY()-DATE and =FIN-DATE.

Of course, your results are in days! If you want them in years, you need to divide by 365.

With a duration in days in cell C4, you will get a clearer reading in D4 with the formula:
=INT(C4/365) & " years and " & C4-(INT(C4/365)*365) & " days".
If this formula scares you, you can break it down by inserting a column that you will hide later, for example, column W. In W4, enter =C4/365; in W5, enter =INT(W4)*365; in W6, enter =C4-W5; then your formula in D4 will be =INT(W4) & " years and " & W6 & " days"!
--
Retirement is great! Especially in the Antilles... :-)
Raymond

So I’ll start again, but I’ll shorten it; too bad for you!
I subtracted N*365 from the number of days to get W6, the number of surplus days.
If you want to continue, just divide this result by 30: In W7 you’ll have the number of months =INT(W6/30).
And in W8 you’ll have =W6-W8*30 left.
If I didn’t suggest this, it’s because there are 2 small issues:
- not all months have 30 days
- if W6<30, the result displayed will look like 2 years, 0 months, and 24 days.
There you go! OK? Best regards.
--
Retirement is great! Especially in the Caribbean... :-)
Raymond

So I’ll start again, but abbreviating; too bad for you!
I subtracted N*365 from the number of days to get W6, the surplus days.
If you want to continue, just divide this result by 30: In W7 you’ll have the number of months =INT(W6/30).
And in W8 you will have =W6-W8*30 left.
If I didn’t propose this, it’s because there are 2 small issues:
- not all months have 30 days
- if W6<30 the result displayed will look like 2 years, 0 months and 24 days.
There you go! OK? Best wishes.
--
Retirement is great! Especially in the Antilles... :-)
Raymond

Hello Raymond,
I therefore avoided the formation of a new setback by going to put my chips in nocturne....!
Thank you infinitely for your, pardon, your explanation, which is even more enlightening with the dazzling sun of this early morning.
--

Friendly greetings.
Jean-Pierre

Hello, dear friend.

"And in W8 it will remain =W6-W8*30": You will have corrected it yourself to =W6-W7*30.
And I didn't purposely, I assure you, send you the same message twice: Don't start thinking that I suspect you of being thick-headed and slow-witted (Woof! woof! woof!)
--
Retirement is nice! Especially in the Caribbean... :-)
Raymond

Hello Raymond,
Thank you, and don't worry, it's perfect.
See you next time.
--

Best regards.
Jean-Pierre

Good evening BEBEN31,
Could you upload your working document on www.cjoint.com and don't forget to post the link, it will be easier to help you!
Here is my example based on Raymond, as the "Datedif" function does not seem to be recognized in OOo: https://www.cjoint.com/?hwwZzEd3FC
--

Best regards.
Jean-Pierre