Substract days which format is in Spanish

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

Guest

Hi, I have a large worksheet with dates in it using spanish format:
dd/mm/aaaa. When I want to substract two dates, as my Operating System and
Excel are in English it consider the date as in english: mm/dd/aaaa.
Therefore the result is wrong. Any suggestions? It is driving me nuts. I've
tried specyfing in the cells format Date Spanish, it still goes wrong. Thanks
in advantage!
 
Hi
if the values are stored as Excel date values the format is not
relevant for mathematical operations. so
A1-A2
should work. Just format the resulting cell as 'Number'
 
Frank, still it doesn't work, the result continues being VALUE. And the
values are stored as Excel date values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Substract two dates in spanish format 4
Display date in spanish 3
Format dates from English to Spanish 2
Date functions in Spanish 3
Formatting dates with =TEXT() 1
"Delocalized" date format 8
Problem with dates 7
formula to subtract 60 days from a date (05/25/2010) 2003excel 3

Back
Top