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?
=(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? Read More
