Hello,
I have an excel cell each for StartDate and EndDate with the format dd/MM/yyyy. After the user enters these dates I am required to create a cell for each day from the start date to end date entered by the user.
For some reason the format on each of these cells is getting changed to MM/dd/yyyy from dd/MM/yyyy
For example:
StartDate 15/01/2015
EndDate 17/01/2015
Cells created: 01/15/2015, 01/16/2015, 01/17/2015
Expected: 15/01/2015, 16/01/2015, 17/01/2015
Code:
Please advise!Please Login or Register to view this content.
Thanks!
Bookmarks