Display Double Digit Month & Day in =MONTH() & =DAY()

[slam]

Is this possible?

I am extracting the year/month/date from a date, but I need it to display as 2 numbers, so April would be 04, but it's only returning 4

=(YEAR(C7))&""&(MONTH(C7))&""&(DAY(C7))

There will be a little more to the formula than this, so I can't just do a straight date format, but this is step 1, before adding the other parts.

Thanks

 

[Jonmo1]

How about
=TEXT(C7,"yyyymmdd")