Hola, como puedo hacer una formula para calcular la edad en años y meses?

[TheTimeSavingCo · Accepted solution]

Usé Google Translate y dijo que te gustaría calcular la edad en años y meses. Si eso es correcto, echa un vistazo a esto*:

 

DATETIME_DIFF(
  TODAY(),
  Date,
  "years"
) 
& " years, " 
& (DATETIME_DIFF(
    TODAY(),
    Date,
    "months"
  ) - 
  DATETIME_DIFF(
    TODAY(),
    Date,
    "years"
  ) * 12
)
& " months"

 Base

*I used Google Translate and it said that you'd like to calculate age in years and months?  If that's correct, have a look at this:

[Alexey_Gusev]

Hi,

just a suggestion - you can also use MOD ( ...months.., 12) for such expressions.

[TheTimeSavingCo]

Oooh, you're right, that's a lot cleaner!