In VBA there is a function called ISDATE(). This is not available in Excel!!!
I have been playing with a spreadsheet to test for data-type. This query originated from a sheet containing a INDEX(MATCH(),MATCH()) type nested function to do a two way lookup of data on the sheet. Based on criteria, the resulting value returned could be a text value, or a Salary or a Date. I was trying to determine the type so I could format the cell as needed to show Salary ® or the dd-mmm-yyyy date format if a date!!
I have a measure of success, except for different date types!
Is there a better (more efficient way) of dealing with this~!!
Steve - How about a custom function!!! <img src=/S/wink.gif border=0 alt=wink width=15 height=15>