You are viewing limited content. For full access, please sign in.

Question

Question

Is there any way to use the =MONTH formula to return a two digit number?

Forms
Updated June 8, 2020
asked on June 5, 2020

Currently, the =MONTH formula is only returning 1 digit when the month is a single digit month. Ex: 06/05/2020 returns "6" as the month, but I'm needing it to return "06", so that all months of the year are 2 digits in length. Is there any way to make this happen?

0 0

Answer

SELECTED ANSWER
replied on June 5, 2020 • Show version history

Hi Dylan,

This should work.

=RIGHT("00" & MONTH(Date),2)

5 0
replied on June 5, 2020

Jim, 

What would we do without you??? That worked like a charm! Thank you so much!

1 0

Replies

replied on June 8, 2020

Oh thanks.  That's a lot cleaner than what I was using. =IF(MONTH(DocumentDate)>9,MONTH(DocumentDate),CONCATENATE(0,MONTH(DocumentDate)))

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...