Sedang Disiapkan

Excel - formula to calculate time period between dates that have varying cell formats and country date formats

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: excel formula days dates, excel formula calculate time, you don t need a crm, i need a crm excel system, formula it, formats in excel, formula time period dates, period, excel formula, data analyse, calculate different, simple crm system, excel format formula, data entry crm system, fix excel, excel format cell, excel cell format, fix formula, need formula, format cell, import data entry excel, excel data analyse, import excel data using, simple system using excel, crm entry

Tentang Majikan:
( 0 ulasan ) London, United Kingdom

ID Projek: #4048776

33 freelancers are bidding on average $37 for this job

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$39 USD dalam sehari
(59 Ulasan)
5.7
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering the usual Open file Lagi

$40 USD dalam 0 hari
(40 Ulasan)
5.4
mrbrave

Lets start...

$30 USD dalam sehari
(67 Ulasan)
5.3
pkcyber

See your PMB

$45 USD dalam sehari
(18 Ulasan)
5.1
pierreho

Dear aelloyd, I have a formula which will satisfy your need. See PM

$40 USD dalam sehari
(24 Ulasan)
4.8
satsin7

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.

$30 USD dalam sehari
(15 Ulasan)
4.5
diegogarcia0531

Hi, I can do the job, Excel expert, VBA developer Please check my PMB I am looking forward to work with you Regards Diego

$30 USD dalam 0 hari
(11 Ulasan)
4.3
rengrish

Hi I have 10+ years of experience in this excel.

$30 USD dalam 0 hari
(27 Ulasan)
4.3
EgyProgramer

Hi, Ready to finish this task right now, kindly check inbox

$30 USD dalam 0 hari
(14 Ulasan)
4.1
microk

***************************** Expert Here. Please check PM. This is Done. *****************************

$30 USD dalam 0 hari
(20 Ulasan)
4.1
FLtowhid

Please see my PM

$30 USD dalam 0 hari
(4 Ulasan)
3.8
manishadk

I also faced same date issue. And solved it successfully. Please check PMB for details.

$30 USD dalam sehari
(10 Ulasan)
3.7
Dutchmatlab

I have some ideas to help you with a simple process for sorting out the date format issues.

$30 USD dalam sehari
(3 Ulasan)
3.6
php4world

Hello! I can create a script that converts dates. Thanks.

$40 USD dalam 0 hari
(6 Ulasan)
3.4
eugene2006

Hi. I interested in your project.

$50 USD dalam sehari
(8 Ulasan)
3.3
renze

I can either: 1) Give instructions how you can import the data (with the corrrect dates) in Excel successfully (no coding, works for other file formats as well), or 2) Write a macro/program to pre process or post pro Lagi

$30 USD dalam 3 hari
(3 Ulasan)
2.7
sumshank

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of Lagi

$50 USD dalam sehari
(3 Ulasan)
2.4
vbexpart

Hire the right one.

$50 USD dalam sehari
(1 Ulasan)
2.5
vinhquy

Let wait me around 20 minutes then I will give you the solution!

$30 USD dalam 0 hari
(2 Ulasan)
1.8
ksharpvw

It is easy for SAS.

$50 USD dalam sehari
(0 Ulasan)
0.0