Validate Date

  • Are there any way, or do anybody have a fuction that can be used in VBA for Excel to validate whether a text string can be converted to a valid date.
    I am making the date string from different conditions like:
    [FONT="Courier New"]String = "2006/02/15"[/FONT] that will be a valid date,
    [FONT="Courier New"]String = "2006/02/30"[/FONT] and [FONT="Courier New"]"2006/04/45"[/FONT] would not be valid.
    Are there any way to test for whether the string will be valid or not?
    Jim Jim