ExcelBanter - Date in Text String

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date in Text String (https://www.excelbanter.com/excel-worksheet-functions/193143-date-text-string.html)

amh

Date in Text String

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

=IF(AA1782G1782,"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

Date in Text String

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

"AMH" wrote:

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

=IF(AA1782G1782,"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

All times are GMT +1. The time now is 01:49 AM.