Date in Text String

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Text String to Date	Bigfoot17	Microsoft Excel Programming	3	11th Apr 2008 02:06 PM
VBA convert day and date from text string to Excel date	Max Bialystock	Microsoft Excel Programming	5	14th May 2007 04:54 AM
Help !, to find last 'text' date in text string	jay	Microsoft Excel Programming	7	10th Apr 2006 10:07 PM
date in text string	Hans	Microsoft Excel Misc	2	13th May 2004 10:44 AM
Date and time text string to date variable	John Marshall, MVP	Microsoft Access Getting Started	4	28th Jan 2004 01:01 PM