Date in Text String

[AMH]

I ahve a formula that displays text and (hopefully) a date into a cell, based
upon some criteria :

=IF(AA1782>G1782,"Week Commencing " & $AA$3,0)

Cell AA3 contains a date, however the formual is true in this case and the
text displayed is

Week Commencing 39643

The 39643 representing the date, how can I convert this to a true date
(should be 14 Jul 08) ?

Thanks

 

[Dennis]

=IF(AA1782>G1782,"Week Commencing " & TEXT($AA$3,"dd mmm yy"),0)