# How can I get a 2 digit month to appear with the following formula

Here is the current formula.

=IFERROR(YEAR([Close Date]@row) + "-" + MONTH([Close Date]@row), " ").

The results of this formula are causing sorting errors. I would like the result when the the month is less than 10 to appear with 2 digits. For example, the current result for September 2022 is 2022-9. I would like it to appear as 2022-09. I tried adding an IF statement on the MONTH, but could not get it to work.

Tags:

• Hi, Matt,

Add "0" to the expression and then take the 2 right-most characters...

RIGHT("0" + ___ , 2)

`RIGHT( "0" + MONTH([Close Date]@row), 2)`

Cheers!

• Hi, Matt,

Add "0" to the expression and then take the 2 right-most characters...

RIGHT("0" + ___ , 2)

`RIGHT( "0" + MONTH([Close Date]@row), 2)`

Cheers!

• Good morning,

Yes, this works perfectly! Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!