Dear All,
Task is very simple, but I need macros which run very very fast and within second remove the time from date for given data.
I have Date from the D to V column in alternative column ONLY. I want only those Columns should check for date and remove of Time from date.
If column empty then ignore that column, first date in those column starts from 3rd Row.
Date given in column like this 8/2/2021 8:30:00 AM and want to remove 8:30:00 AM, and remain keep date as per the given format in excel 8/2/2021 means 2-Aug-21
Pls identify the last row in each column to make changes or advise your best ways to identify the last row of each column date.
Other factors,
I am not aware too much on scripting directory, but that helps to quickly run macro so pls use in coding.
Ozgrid Pay done 10%
Thanks, r_know