# Calculating months, days, years

I am looking for a formula that takes an employees hire date subtracted from todays date and tells me how long they have been employed in the form of xdays, xmonths, xyears , all I can figure out is how to calculate the total number of days.

Hi @Johnsa9 - while I could not get this working in a native monday Formula column, I was able to make it work with General Caster. Here is the formula:

DATEDIF(0,DAYS(TODAY(),{itemâ€™s Start Date}),â€śyâ€ť)&" years " &
DATEDIF(0,DAYS(TODAY(),{itemâ€™s Start Date}),â€śymâ€ť)&" months â€ś&
DATEDIF(0,DAYS(TODAY(),{itemâ€™s Start Date}),â€śmdâ€ť)&â€ť days"

@JCorrell - DATEDIF isnâ€™t supported in monday, any thoughts on how to do this directly in a monday formula column?

Hope this helps!
Mark

1 Like

@mark.anley

This will get pretty close:

``````INT(YEARFRAC(FORMAT_DATE({Date}), FORMAT_DATE(TODAY()))) & " Years " &
INT(MOD(YEARFRAC(FORMAT_DATE({Date}), FORMAT_DATE(TODAY())), 1) * 12) & " Months " &
INT(MOD(YEARFRAC(FORMAT_DATE({Date}), FORMAT_DATE(TODAY())) * 12, 1) / 12 * 365) & " Days"
``````

Jim - The Monday Man
Column Magic - the magical columns toolbox app

4 Likes

Thank you! This worked exactly as I needed it to. I downloaded the Column magic app for another board and it worked for a second but now none of the columns are populating the formulas! I am not sure what to do.

Thank you! I like that general caster however I could only use it so many times in a month and I exceeded that.

@Johnsa9

Submit your information here and I will see if I can help.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.