Date format handling when Exported to Excel

Date format handling when Exported to Excel

Hi,

Do you have the issue of handling Date in Excel when you export your data? if you have Lead Creation time in one column and Activity Time in another column, how do you calculate the difference between these two in terms of minutes?

=month() function gives me day as output
=day() function gives me month as output
so 12/10/2014  will give output as 12 for month and 10 for day

These function stop working when date crosses 12th as there is no 13th month.

Zoho support does not know how to handle this, are you also having same issue in handling dates?

I have attached screenshot where you can clearly see two different date formats being used.