Tenure formula based on end of current month?

[Sunshine8790]

I'm not quite sure how to actually go about this.
I need a formula to calculate tenures in years based on date of hire and end of current month.

For instance this is an example sheet (range including headers goes from E1 to G5):
My formula in G2 is

=IFERROR(DATEDIF(F2,NOW(),"Y"),"Inactive")

This formula is based on date of hire and current date though. I need to to calculate the date of hire against the END of whatever current month it is.
So, for instance - John Doe should say "10" as opposed to 9, because although it's not the 28th of June yet, he would be celebrating his 10th year this month.

Help?

Name	Date of Hire	FORMULA
Jane doe	3/20/2024​	0​
John Smith	9/29/1992​	31​
John Doe	6/28/2014​	9​
Jane Smith	8/8/2015​	8​

 

[Joe4]

Change your formula like this:

=IFERROR(DATEDIF(F2,EOMONTH(NOW(),0),"Y"),"Inactive")

 

[Sunshine8790]

Change your formula like this:

=IFERROR(DATEDIF(F2,EOMONTH(NOW(),0),"Y"),"Inactive")

Works perfectly! Thank you!!

 

[Joe4]

You are welcome.
Glad I was able to help!