Different date formats

kasbac

Active Member
Joined
Jan 2, 2008
Messages
344
Hi there

I have the follwing formula working out how many days within a particular month a machine will occupied based on a starting and end date that i get from a system report.

=MAX(0;MIN(VALUE($Z2);DH$1+31-DAY(DH$1+31))-MAX(VALUE($Y2);DH$1)+1)

When I pull the report the date's (in coulmn Y and Z) comes out in a format like this: 30-07-2010 and the formula works fine.

I now intend to hand this formula over to a colleauge in an other region than where i am. When she pull out the same report the date format is shown as such: 30.07.2010. It appears as if the formuals no longer can handle this format? Does anyone have any idea how I can work around this problem?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

ashleywanless

Board Regular
Joined
Aug 4, 2009
Messages
158
Excel doesn't recognise dd.mm.yyyy as a date. If this is how the System generates the report I would record a macro to throw at it. The macro just needs to be a find . And replace with / you should be able to use the recorder to get the code you need
 

Watch MrExcel Video

Forum statistics

Threads
1,123,511
Messages
5,602,078
Members
414,500
Latest member
kevdragon1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top