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
Searching the formula (not the value) for a text string 1
Convert Date in Text to month and Year 3
Special string convertion to date and time 5
Another Date formula question 3
Populating adjacent cells 4
IF(AND(OR function returns #VALUE! error 3
Counting number of rows between date range and meeting 2 string criteria 11

Top