I have a spreadsheet that contains dates amongst other items. Sometimes the opperator enters the date a dd/mm/yyyy for eg 01/10/2006 and sometimes as 10/01/2006. I want all dates entered as dd/mm/yyyy.
I would like VBA code to be written that will convert all dates entered as mm/dd/yyyy that is after the current date in cell A2 (i.e todays date 07//10/2006)
for eg if the date is entered as 07/12/2006 which is after the todays date 07/10/2006, then the date must be converted to 12/07/2006.
Your assistance will be most appreciated.
Howard
I would like VBA code to be written that will convert all dates entered as mm/dd/yyyy that is after the current date in cell A2 (i.e todays date 07//10/2006)
for eg if the date is entered as 07/12/2006 which is after the todays date 07/10/2006, then the date must be converted to 12/07/2006.
Your assistance will be most appreciated.
Howard