Hello! Does anyone know a way that I can use a formula to convert a year to a decade? Forgive me if this is simple, I am new to formulas… Thanks!

I believe it’s something like
`FLOOR(YEAR(Date),10)`

Thanks, I’ll try that. Where exactly would I put in the target field that has the date in it?

Hmm. that doesnt seem to work…

my formula takes a date, extract the year, and returns the decade.
If you already have the year try
`FLOOR(year,10)`

Ok, it does in fact work. Maybe you can help me with one more thing. As it is now, it shows me the result as a 4 digit year, for example 1982 or 1983 will both return 1980 for the decade. Is there a way to make the result show as just the last two digits? like “80s” or “90s” ?

Thanks again

this worked for me
`CONCATENATE(FLOOR(year,10)-FLOOR(year,100),"s")`

Thats wonderful, thank you so much! Last one but not a big deal. This returns everything perfectly like "80s, 90s) etc. except for the 2000s which just comes back as “0s”… any ideas there?

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.