DATEDIF date format

  • Thread starter Thread starter Stig
  • Start date Start date
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
 
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.
 
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
 
Have you set the date formats under Control Panel - Local (or Regional)
Settings to the short date format of dd/MM/yyyy ?

Peter
 
Back
Top