USING DATES IN FORMULAS
 

I foubd a problem with excel 2003
If you introduce a formula using dates (in spanish version) (dd/mm/yy),
excel doesnt makes the calculation........... ???? Can somebody hep me

USING DATES IN FORMULAS
 

In the USA version (English), I could use:

=if(a1=date(2005,10,27),"It's Oct 27, 2005","it's not")

to refer to a date.

I don't know what the Spanish function is for =date(), though.

Carlos Benavides wrote:

I foubd a problem with excel 2003
If you introduce a formula using dates (in spanish version) (dd/mm/yy),
excel doesnt makes the calculation........... ???? Can somebody hep me

--

Dave Peterson

USING DATES IN FORMULAS
 

What DOES happen, Carlos? Give us the values in the cells and the formulas,
and tell us the results.
************
Anne Troy
www.OfficeArticles.com

"Carlos Benavides" <Carlos wrote in
message ...
I foubd a problem with excel 2003
If you introduce a formula using dates (in spanish version) (dd/mm/yy),
excel doesnt makes the calculation........... ???? Can somebody hep me