I'm looking to convert a date into yyyyMMdd format. I just want an 8 digit year month and day format.

This works to convert the current date: 

=CONCATENATE(TEXT(Year(now())), right(CONCATENATE(0,TEXT(Month(now()))),2), right(CONCATENATE(0,TEXT(Day(now()))),2))

I tried to figure out how to use the TEXT() to format the the Month and Day into 2 strings with the leading zeros. I tried things like: TEXT(Month(now()), "0d")  or TEXT(Month(now()), "D2") or TEXT(Month(now()), "dd") ,....

But I could never get the format to give me a two digit month. The only time I could get it to work was when I had not formatting.

Does anyone know how to use the format part of the TEXT(number, format) formula?