Skip to main content
Solved

Change year to decade

Forum|alt.badge.img+12

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!

Best answer by Ilan_Ben_Yaakov

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

View original
This topic has been closed for replies.

7 replies

Forum|alt.badge.img+7

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

Forum|alt.badge.img+12

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?

Forum|alt.badge.img+12

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


Hmm. that doesnt seem to work…

Forum|alt.badge.img+7

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)

Forum|alt.badge.img+12

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

Forum|alt.badge.img+7

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

Forum|alt.badge.img+12

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