Concatenate and date format

[Guest]

H
Im using the foloowing formula...
=CONCATENATE(YEAR(B55)&MONTH(B55)&DAY(B55)&IF(HOUR(C55)>=12,"P","A")) Where B55 has current date formatted as MM/DD/YYY
How can I get the month(b55) to return 04 rather than

Thanks!

 

[DDM]

Billy,
=CONCATENATE(YEAR(B55)&TEXT(MONTH(B55),"00")&DAY(B55)&IF(HOUR(C55)>=12,"P","
A")).

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

Hi
Im using the foloowing formula....
=CONCATENATE(YEAR(B55)&MONTH(B55)&DAY(B55)&IF(HOUR(C55)>=12,"P","A"))

Where B55 has current date formatted as MM/DD/YYYY

 

[Peo Sjoblom]

Why complicate things?

=TEXT(B55,"yyyymmdd A/P")

will do