How can I display the current month number as a 2-digit number so it matches my year-month?

martinem1

My ultimate goal is to create an automation that will look at the total audits completed for the current month and if the number <10, a notification will be sent. In order to do that, I need the 'current month' and 'current year' formats to match the 'Month' and 'Year' formats. I have tried =TEXT(TODAY(), "MM") but get an unparsed error. Please help!

VBAGuru

You could try

=IF(LEN(MONTH(TODAY())) = 1, "0" + MONTH(TODAY()), MONTH(TODAY()))

VBAGuru

You could try

=IF(LEN(MONTH(TODAY())) = 1, "0" + MONTH(TODAY()), MONTH(TODAY()))

martinem1

Yes, this worked! I had tried a version of that formula before but was missing something. Thank you so much!

VBAGuru

Happy to help!