SOLVED

Count number of Years, but not in sequence

Copper Contributor

I need to count the number of years a person worked.   For example in this range of dates, the correct count is 5.   What would be the formula?

 

1/1/1975

3/1/1975

4/1/1976

5/1/1976

2/25/2011

12/15/2013

12/31/2013

6/17/2022

7/31/2022

9/17/2022

 

TIA

Mike

1 Reply
best response confirmed by squid2023 (Copper Contributor)
Solution

@squid2023 Use the following formula-

=ROWS(UNIQUE(YEAR(A1:A10)))

Harun24HR_0-1709266432023.png

 

 

1 best response

Accepted Solutions
best response confirmed by squid2023 (Copper Contributor)
Solution

@squid2023 Use the following formula-

=ROWS(UNIQUE(YEAR(A1:A10)))

Harun24HR_0-1709266432023.png

 

 

View solution in original post