Formula working in one computer but not on another...HELP

[gmouttou]

I have a Age calculating formula in an excell cell, which calculates the age as on another date.
The forumala is =IF(E4="","",IF($C$1="","",ROUNDDOWN(($C$1-E4)/365,0))) where E4 is the date of birth and C1 is the date in which I want the age calculated to be.

The above formula works very well on my computer, but does not on any other computer. If I access it from my sent items or from a shared drive, it works perfectly on mine, but not on any other computer!!! I get a #value error message on all other computers.

I have tried the foll:
If i enter =ISNUMBER(C1) where the age has to be calculated, I get #Name?
If I enter =ISNUMBER(E4), i get TRUE
The above is on the sheet where it does not work ( on others computer ) and i get TRUE for both on mine.
Also both have the same date formats and same time zones...

Pls help!

Thanks.

[Pecoflyer]

Perhaps your local settings are different and you need to use a semi-colon instead of a comma?

OTH you can also use =IF(OR(E4="",$C$1=""),"",DATEDIF(E4,$C$1,"y"))))

[gmouttou]

Perhaps your local settings are different and you need to use a semi-colon instead of a comma?

OTH you can also use =IF(OR(E4="",$C$1=""),"",DATEDIF(E4,$C$1,"y"))))

Thanks. Where do you want me to put the semi-colon? Wherever the commas are? Tried but does not accept the formula...

=IF(OR(E4="",$C$1=""),"",DATEDIF(E4,$C$1,"y")) This works..again only on my computer..

[Pecoflyer]

Like this =IF(OR(E4="";$C$1="");"";DATEDIF(E4;$C$1;"y")))) ?