Years as a member

%3CLINGO-SUB%20id%3D%22lingo-sub-1638749%22%20slang%3D%22en-US%22%3EYears%20as%20a%20member%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638749%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20count%20a%20number%20of%20years%20a%20member%20has%20belonged%20to%20the%20group%2C%20but%20only%20if%20they%20have%20paid%20their%20dues%2C%20how%20do%20I%20do%20that%3F%20I%20list%20in%20a%20column%20the%20date%20they%20paid%20their%20dues%2C%20and%20I%20would%20like%20the%20continuous%20years%20column%20then%20to%20figure%20the%20number%20of%20years%20they%20have%20belonged%20if%20their%20is%20a%20date%20in%20that%20column.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1638749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1638936%22%20slang%3D%22en-US%22%3ERe%3A%20Years%20as%20a%20member%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638936%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783367%22%20target%3D%22_blank%22%3E%40LPBKessler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20a%20formula%20like%20in%20the%20attached%20file%3F%20It%20will%20show%20zero%20if%20the%20dues%20cell%20is%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%2C%20if%20you%20want%20it%20to%20display%20something%20else%2C%20you%20could%20use%20an%20IF%20function%3A%3C%2FP%3E%3CP%3E%3DIF(B2%26gt%3B0%2C%26nbsp%3BDATEDIF(A2%2CTODAY()%2C%22y%22)%2C%20%22NOT%20PAID%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm trying to count a number of years a member has belonged to the group, but only if they have paid their dues, how do I do that? I list in a column the date they paid their dues, and I would like the continuous years column then to figure the number of years they have belonged if their is a date in that column. 

1 Reply

@LPBKessler 

 

Perhaps a formula like in the attached file? It will show zero if the dues cell is blank.

 

Or, if you want it to display something else, you could use an IF function:

=IF(B2>0, DATEDIF(A2,TODAY(),"y"), "NOT PAID")