Forum Discussion
Embry3894
Jul 16, 2024Copper Contributor
Datedif with hired date term and rehire
=(DATEDIF(E26,F26,"Y")+DATEDIF(K26,$L$2,"Y"))&" Y "& (DATEDIF(E26,F26,"YM")+DATEDIF(K26,$L$2,"YM"))&" M"
This is giving me months greater than 12. How do I correct this?
2 Replies
Sort By