I get a date from Date.Today.ToString(“dd/MM/yyyy”) and my date format in Excel is English(United Kingdom) which is same format (dd/MM/yyyy) . However when I use ‘Write Cell’ function into Excel sheet the format turns to “MM/dd/yyyy”.
How can I solve this problem? (Yes I tried calculate again and text to column function but they don’t fix it neither.)
Also what I realized, it only does this error while there is 01 in the date. So today is 02/01/2020 according to my format bit it keeps writing 01/02/2020 to excel. This error keeps happening to me if there is ‘01’ in the date doesn’t matter in month or day part.
Thanks in advance