Help

Change year to decade

Topic Labels: Formulas
Solved
Jump to Solution
1675 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Dennis_Petrou
7 - App Architect
7 - App Architect

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!

1 Solution

Accepted Solutions
Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

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

See Solution in Thread

7 Replies 7
Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

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

Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

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?