Forum Discussion

MariaPace's avatar
MariaPace
Qrew Member
4 years ago

Calculate year and month tenure from two dates

I have a form with start date and end date. How do I calculate tenure in years and months (e.g., 3 years 4 months) based on these two dates? ------------------------------ Maria Pace ------------...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
OK, let's go back to basics, maybe I have way over complicated this.

Can you give me an example of the start date and the end date and the response you want from the formula.  

If you just want the Duration then you just subtract

[End date] - [Start Date]


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MariaPace's avatar
MariaPace
Qrew Member
4 years ago
The duration works but I get it in days and would like it in year and month. So if start date is 11/01/2020 and end date is 12/05/2021 the duration would be 1 year 1 month.

------------------------------
Maria Pace
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Can you post your current formula with a copy paste (not a screenshot)?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------