Calculating the Difference Between 2 Dates

[jason_kelly]

Hi There,

I need your help.

I can't seem to wrap my head around this:

I have the following code:

Please Login or Register  to view this content.

and it returns 31 when it should be returning a date difference of 1.

I need the date in the following format dd/mm/yyy

Any help with this is greatly appreciated.

Thanks.

Jay

[Leith Ross]

Hello Jay,

The problem is how VBA handles dates. The best thing to do is use unambiguous date formats. The date "04/02/2011" in UK date format is Feb. 04, 2011. In US date format it is April 02, 2011. The code below corrects the problem by converting the dates into numbers.

Please Login or Register  to view this content.

[jason_kelly]

Thanks very much Leith.

It works like a charm!

You are a god!

Thanks again.

Jay.