Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Change year to decade

Topic Labels: Formulas
Solved
Jump to Solution
382 7
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

See Solution in Thread

7 Replies 7

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?