View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default 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