DATEDIF date format

S

Stig

Hi
Is there a way of using the DATEDIF function using the UK way of displaying
dates? (dd/mm/yy)
if i want to use it I have to format the dates referred to in US style.
My regional settings in control panel ar all set to UK spec and the dates in
other parts of Excel all display in this manner.
Thanks
Dave
 
B

Bob Phillips

Dave,

What do you mean you have to have the dates in US style? I also have UK date
style, and I put dates in UK style in A1 and A2, and did a DateDif, no
problems. I also tried =DATEDIF("01/08/2005",A2,"m"). no problems.

It shouldn't make a difference, as dates are just numbers, so Excel holds
dates as numbers and calculates based upon the numbers. The date style will
tell Excel how to interpret the date input into the correct number value.
 
S

Stig

Bob
Thanks for the reply.
That's what I thought should happen but I couldn't get it to work unless i
changed the dates to US format. After that it worked perfectly. Bizarre!
Dave
 
P

Pete

Have you set the date formats under Control Panel - Local (or Regional)
Settings to the short date format of dd/MM/yyyy ?

Peter
 
Top