USING DATES IN FORMULAS

C

Carlos Benavides

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
 
D

Dave Peterson

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.
 
Top