I have a spreadsheet where the dates are all in column C. The dates should be inputted as dd/mm/yyyy for eg 10/08/2006. Sometimes the operator types in the date as 08/10/2006 which is after the todays (Current) date
I need VBA code that will covert dates after the current date in column C for eg 08/10/2006 to the correct date ie 10/08/2006.
I have set up the the formula =now() in cell A2
Your assistance will be most appreciated.
Howard
I need VBA code that will covert dates after the current date in column C for eg 08/10/2006 to the correct date ie 10/08/2006.
I have set up the the formula =now() in cell A2
Your assistance will be most appreciated.
Howard