I'm trying to find the how many years individuals have been club members. The problem is the joining date is just the year e.g. 15

[djurmann2]

Hello,

My wife is membership secretary for a club and they want to honour people who have been members for a significant length of time. I thought I could maybe use a date formula and the today() function but the fact the date they joined is just the year... eg 97, or 15 complicates things.

Any suggestions most welcome!

Thank you very much,

Danny

 

[Fluff]

Hi & welcome to MrExcel.
What is the earliest year?

 

[djurmann2]

89

Also just for fun they've done 05 as O5

Tbank you for your help

 

[Fluff]

Ok, how about

Fluff.xlsm
	A	B
1
2	97	26
3	15	8
4	1	22
5	O5	18
6	23	0
Main

Cell Formulas
Range	Formula
B2:B6	B2	=LET(a,--SUBSTITUTE(A2,"O",0),YEAR(TODAY())-IF(a>89,a+1900,a+2000))

 

[djurmann2]

Ok, how about

Fluff.xlsm
	A	B
1
2	97	26
3	15	8
4	1	22
5	O5	18
6	23	0
Main

Cell Formulas
Range	Formula
B2:B6	B2	=LET(a,--SUBSTITUTE(A2,"O",0),YEAR(TODAY())-IF(a>89,a+1900,a+2000))

You're a genius! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.