+3Hi!
First of all, I am french so I hope you’ll understand my question. :hugs:
I’d like to calculate how long has an employee been with the company, so : since entry date (fr: date d’embauche) until now/today.
I already have a formula that calculates the number of years (fr: années) and another formula that calculates the number of months (fr: mois) but I’d like to have these informations in one formula.
Is that possible ?
Thanks !
Best answer by kuovonne
IF(
{Birthdate},
CONCATENATE(
DATETIME_DIFF(TODAY(), {Birthdate}, "years"),
" années ",
MOD(
DATETIME_DIFF(TODAY(), {Birthdate}, "months"),
12
),
" mois"
)
)
+29Welcome to the Airtable community!
Try TONOW({date d’embauche}) and see if that is what you want. The result will probably be in English, though.
+3Welcome to the Airtable community!
Try TONOW({date d’embauche}) and see if that is what you want. The result will probably be in English, though.
Omg it worked, thank you so much !!
+3Welcome to the Airtable community!
Try TONOW({date d’embauche}) and see if that is what you want. The result will probably be in English, though.
Hi again!
Do you think there is a way to have the number of years AND months calculated for each person?
For example (screenshot bellow), the first line, this person has been with the company for 12 years and 6 months, not 13 years. Is there a way to get more accurate results or am I asking too much? :smiling_face_with_tear:
Thank you in advance**
+29IF(
{Birthdate},
CONCATENATE(
DATETIME_DIFF(TODAY(), {Birthdate}, "years"),
" années ",
MOD(
DATETIME_DIFF(TODAY(), {Birthdate}, "months"),
12
),
" mois"
)
)
IF(
{Birthdate},
CONCATENATE(
DATETIME_DIFF(TODAY(), {Birthdate}, "years"),
" années ",
MOD(
DATETIME_DIFF(TODAY(), {Birthdate}, "months"),
12
),
" mois"
)
)
You are genius thank you sooooo much!!! And it’s in French! :partying_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.