How do I only get the 25, 26, 27, etc out of 2025, 2026, 2027?

mtuccillo

I need to pull out the last 3rd and 4th characters of a long year format CCYY where I only pull out the YY. So, in my example, I need to find the year 25 out of 2025. 26 out of the year 2026, 27 out of the year 2027 and so on. Basically ignore the first two characters of the long year 2025 so I will only be seeing the 25 out of the year.

Does anyone have an idea on how to do this?

Thank you!

Adam Murphy

Hi @mtuccillo,

I would use the RIGHT function and specify 2 characters. Something like this: =RIGHT(YEAR(TODAY()), 2)

Hope this helps!