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

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.

Hello,

I have attached a small portion where i hv the problem.C1 is the cell where the date is to be entered and E4 is where the date of birth is to be entered and the age should be caluculated as per the date in C1.

Many Thanks.

sorry, the password is asd

Thanks...I cannot have =TODAY() in C1 as the age has to be caluculated based on the day in C1, which would mostly be a date in the future. So I am not using any formula in C1 and i do enter a proper date.....

Originally Posted by daddylonglegs

OK that works for me too, so if it doesn't work for you it may be some computer setting - your profile says Excel 2003 - is that the version you are using?

How are you entering the date exactly? With slashes like 1/1/2013 or some other way?

This is within an office environment and hence all of us have the same excell version. I enter the date in dd.mm.yy and have also tried dd/mm/yy and both do not work...

Can someone help!!!