Calculating length of service

Platform discussions
,
1

Hi there,

I need to be able to calculate the length of service for staff. I have a start date column and a today’s date column but can’t get anything to work with formulas.

Ideally it needs to be a running total with years, months and days.

I found the following formula for days but just figure out how to get a running total with years.

ROUND(DAYS({Due Date},TODAY()),0)

Help please :slight_smile:

2

Hi @Ng84 - if you divide your formula by 365 you will get the years:
ROUND(DAYS({Due Date}, TODAY()) / 365, 2)

Hope this helps!
Mark

3

Hi Nikki,

Try:

INT(DAYS(TODAY(),{Date})/ 365) & " years, " & INT((DAYS(TODAY(),{Date}) - (INT(DAYS(TODAY(),{Date}) / 365) * 365)) / 30) & " months, " & (DAYS(TODAY(),{Date}) - (INT(DAYS(TODAY(),{Date}) / 365) * 365) - (INT((DAYS(TODAY(),{Date}) - (INT(DAYS(TODAY(),{Date}) / 365) * 365)) / 30) * 30)) & " days"

To get it in this format: 5 years, 6 months, 11 days

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.