PC Review


Reply
Thread Tools Rate Thread

Date in Text String

 
 
AMH
Guest
Posts: n/a
 
      30th Jun 2008
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


 
Reply With Quote
 
 
 
 
Dennis
Guest
Posts: n/a
 
      30th Jun 2008
=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
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:44 AM.