Hello all,
Hope all is going well. I am trying to modify an excel worksheet using VBA. In a cell I have date and time showing in one cell (ex: 04-09-2018 8:06:21am) but I only want to extract the date out of the cell.
I would like to do this with the entire column (column Q starting Q11 and down). After the entire column is selected, I would like to only extract the date out of that column and if the date of is NOT a weekend then I would like to delete that entire row. any help would be appreciate it. Thank you
Capture.JPG