Substract two dates in spanish format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large worksheet with dates that are in Spanish format: dd/mm/aaaa.
My Excel and Operating system are in English, so when I want to substract two
dates the result is wrong as it considers: mm/dd/aaaa. I've tried to put the
format in these cells in Spanish but it still doesn't work. It is driving me
nuts and I've got thousands of dates, cannot consider changing them manually.
Any ideas?

Thxs in advance.
 
How about converting them to mm/dd/aaaa with:

=DATE(RIGHT(A1,4),MID(A1,FIND("/",A1)+1,2),LEFT(A1,FIND
("/",A1)-1))

HTH
Jason
Atlanta, GA
 
Now that I think about it a bit more, are you sure? Aren't the dates text?
Otherwise, why never a day > 12?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Thks! this worked perfectly

Jason Morin said:
How about converting them to mm/dd/aaaa with:

=DATE(RIGHT(A1,4),MID(A1,FIND("/",A1)+1,2),LEFT(A1,FIND
("/",A1)-1))

HTH
Jason
Atlanta, GA
Click to expand...
 
Back
Top