=DATEDIF(A5;B5;"y")&" Years "&DATEDIF(A5;B5;"ym")&" Months "&DATEDIF(A5;B5;"md")&" Days "
____________________________
OpenOffice 3.4.1;Win7
=(EndDate - StartDate) / 30.42
formatted to
0.00" months roughly"
This is answered for OpenOffice in [Tutorial] Calc date formulas, Section D. Determine years/months/weeks/days between dates. I believe you want the formula shown for "As nnM nnD" (months and days).Ssronica wrote:Instead of Calc returning a value of 185 days, I sort of need it to say "6 months, 3 days"
AOO does not have DATEDIF but can easily perform the calculation.Zizi64 wrote:Apache OpenOffice has not such function.
As you would know, this is an estimate which may be particularly vulnerable in cases where the result is close to an integer, for example from February 1 to March 2, where the quotient is 0.986. AOO provides functions for an exact calculation: 1 month and 1 day.Lupp wrote:=(EndDate - StartDate) / 30.42
Switch office suites if you like, but there is no need for you to do so just to resolve this topic. The formula in the tutorial will work with OpenOfficce 3.4.1.Ssronica wrote:I have a fairly extensive spreadsheet - do you know if it will be compatible in LibreOffice?
MrProgrammer wrote:...AOO provides functions for an exact calculation: 1 month and 1 day.
MrProgrammer wrote:Lupp wrote: =(EndDate - StartDate) / 30.42
As you would know, this is an estimate which may be particularly vulnerable...
Users browsing this forum: No registered users and 30 guests