VBA macro in Excel 2003 help

Discussion in 'Software' started by AccessShell, Apr 23, 2015.

  1. AccessShell

    AccessShell Private E-2

    I have a column of dates in "ddd mmm dd, yyyy" format. I need to test if the dates are valid. I can easily step through the column and get the value in the cell. However, when I try the isDate function, all entries are false. I just need to make sure the ddd part is correct for the mm dd, yyyy part.

    Thanks in advance
     
    AccessShell, Apr 23, 2015
    #1

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds