I'm Stumped: Date in the formula line BEFORE text - Pic attached

[fredieusa]

I just cannot figure this out.

I cannot seem to get the date in front of the text that i want the formula to pull. Please help me overcome this.. My head hurts. Thank you.

 

[Hui]

=if(B1=0,"","Classroom date: "&text(B1,"mm/dd/yy")& " Held at: "&B2&" "&B3&", "&B4&" From: "&B5& " to: "&B6)

If B5 & B6 are times
=IF(B1=0,"","Classroom date: "&TEXT(B1,"mm/dd/yy")& " Held at: "&B2&" "&B3&", "&B4&" From: "&TEXT(B5,"hh:mm")& " to: "&TEXT(B6,"hh:mm"))

 

[fredieusa]

Hui, you are a genius! Wow, thank you soooo very much! you hit it smack on the head. If you are anywhere around Nor Cal, i have to buy you a beer!

 

[fredieusa]

you actually improved it by formatting in the times! bow down to you in respect.