I have written a vba code to update date in A1 . I have selected Date option in format cells and selected type as "14/03/2001" and has written the following the code. But still it shows me as 04/01/2013( meaning 4 january) instead of 01/04/2013 (meaning April 1st). Any tool by which i can control dates and time in the way that i wanted.

Please Login or Register  to view this content.