one of my developer is working on some automation currently there is a column on the excel which has a date and the program increment date on each data row now this program works perfectly fine on his pc however when i try on my pc it doesnt work i have tried like 4 pc so far but all have the same issue
it is adding month instead of days
previous sheet dates
26-Dec-11 27-Dec-11 28-Dec-11 29-Dec-11 30-Dec-11 31-Dec-11 1-Jan-12
generated sheets dates
1-Feb-12 1-Mar-12 1-Apr-12 1-May-12 1-Jun-12 1-Jul-12 1-Aug-12
the image shows the code used.