Date in Text String

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying a date into a text string 3
Convert Date in Text to month and Year 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Text box to display week commencing date? 1
When using & and a date-formatted cell in a formula I lose the for 2
Date format in a text string 15
date in text format as a real date 2
Filling in a cell based on another cells date criteria 3

Top