LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to test text string to know if it is a date


I want to make a boolean function (isDate) to test if the text in a cel
is a date or a simple text (comments or other)

How to do that?

Thanks

iTarna

--
itarna
-----------------------------------------------------------------------
itarnak's Profile: http://www.excelforum.com/member.php...fo&userid=2786
View this thread: http://www.excelforum.com/showthread.php?threadid=47409

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to get date from text string Sara Excel Worksheet Functions 2 May 18th 10 10:51 AM
Date in Text String AMH Excel Worksheet Functions 1 June 30th 08 03:39 PM
test text string for a comma (,) JR Hester Excel Discussion (Misc queries) 3 June 24th 08 04:14 AM
Need to test for a specific text string and write value to another Pyramid 36 Excel Worksheet Functions 2 August 3rd 07 12:55 AM
test cell for text string; return value if condition is true Steve[_63_] Excel Programming 2 July 8th 04 04:55 AM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"