I need to calculate the number of days between 2 columns of dates in Excel.
The data imports from my CRM system using US date format into UK Excel and gets confused in the process.
As a result, dates that make sense in UK date format import incorrectly as UK dates (e.g. 12/03/2012 which is Dec 3 12 in CRM system is imported as 12 March 12) and dates that don't make sense in UK format are imported as "general" content.
This mixture makes it difficult to analyse the data.
Can you create a formula or simple process that will allow me to fix the data so the amount of time between both dates can be calculated.
I need to do this every month with different data sets so the formula/process needs to be easy to replicate every month.
I attach an example file.
33 freelancers are bidding on average $37 for this job
I love working with dates. My solution is simple and easy. No import or export or fox pro programming etc. required. You can do it from excel itself. Please see PMB and provide the clarifications.