Originally Posted by
RAJESH SHAH
The dates are in the general format but read as dd/mm/yyyy
No as explained since post #5
your columns are Text rather than Date and Ali well described how to see if it's Text or Date
like this was yet explained in your threads
So the question is again how do you get this Text looking as date ?
If it is from an importation as often in your projects so the smart way is to just correct it in order to get directly Excel dates (stored as numbers)
as there is 'no sense' to correct the data after when the importation can be directly corrected, your project will look pro & smarter
If you do not import it then if necessary just create a specific VBA procedure to convert the Text to Date
easy with the VBA TextToColumns method just with a single statement
So once the columns are converted to numbers (aka dates) you can't have any more issue if the Excel logic is well understood & followed.
Bookmarks