Skip to main content

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)

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?

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


Hmm. that doesnt seem to work…

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


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

I believe it’s something like
FLOOR(YEAR(Date),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")

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?

Terms & ConditionsAccessibility statement