Forum Discussion

squid2023's avatar
squid2023
Copper Contributor
Mar 01, 2024
Solved

Count number of Years, but not in sequence

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 ...
  • Harun24HR's avatar
    Mar 01, 2024

    squid2023 Use the following formula-

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

     

     

Resources