HI there,
I have been struggling with this formula. I have created a sheet where clients join a women's group and then either resign / move to another town. Each town has a women's group where they can then join again.
I have the formula to work out how many years and months a person was at a particular area before they moved to another town or resigns. Formula: =IF(DATEDIF(AA5,AB5,"y")=0,"",DATEDIF(AA5,AB5,"y")&" years ")&IF(DATEDIF(AA5,AB5,"ym")=0,"",DATEDIF(AA5,AB5,"ym")&" months " - it works perfectly, showing the years and months based on the two dates provided.
At the end of the row, I would like to calculate all the years and months combined as they receive a reward based on the amount of years they have been part of this women's group. How can I get the total years and months based on the various DATEDIFs? I have attached a document as an example.
Thanx
Bookmarks