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
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.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.