Transformer
06-03-2013, 10:00 PM
UsefulGyaan Has Posted the Following On 06-03-2013 10:29 PM:
In Microsoft Excel, this function returns TRUE if the expression is a DATE, otherwise FALSE. The Syntax for the function is: IsDate(expression) And the examples are: *Isdate("January,2013") 'will return True Isdate("23 January,2013") 'will return True Isdate("January 23,2013")** 'will return True Isdate("22-1-2013") ' will return True BUT IsDate("Theodoulus 22 Jan, 1985") ' will return False Filed […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=861&subd=usefulgyaan&ref=&feed=1
IsDate() Function : VBA (http://usefulgyaan.wordpress.com/2013/06/03/isdate-function-vba/)
In Microsoft Excel, this function returns TRUE if the expression is a DATE, otherwise FALSE. The Syntax for the function is: IsDate(expression) And the examples are: *Isdate("January,2013") 'will return True Isdate("23 January,2013") 'will return True Isdate("January 23,2013")** 'will return True Isdate("22-1-2013") ' will return True BUT IsDate("Theodoulus 22 Jan, 1985") ' will return False Filed […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=861&subd=usefulgyaan&ref=&feed=1
IsDate() Function : VBA (http://usefulgyaan.wordpress.com/2013/06/03/isdate-function-vba/)