=if(b13="","",(days360(b13,$c$6))/360) - formula works on my laptop - not on other pc's

The only thing I can think of, is hit the upper left "Office" icon , and check the formulas setting, advanced settings and/or trust settings, all 3 of theses can affect what happens with the calculations, also, I would try to use the evaluate formula tool to see WHY it gives a #value! error,this could be a simple error in data transfer, or a completely un-recgonised add-in that does not exist on the office computers (although that should generally lead to a #name! error, if the name is the same, it could give the #value! error as well)
please check these and advise

On MY computer, I see NO errors, is it possible to upload a sample from one of the computers that give you the errors?
( I'm not truly sure this will help, but if it errors when the solution is uploaded from one of those, then maybe we can narrow the problem down )

EDIT-
just thought of another posible cause..."sharing" can be a possible cause, if you allow sharing on your home network, but it is not allowed at work, this may cause problems
(or vice versa)

I tried it too, and it works for me - Win 8, excel 2007 and 2010

perhaps the regional settings are different. if the value in B13 is not recognized as a date you will get a #VALUE error

I'm not sure why you get problems with that formula. Are you trying to get the age as a decimal number of years (that's what you'll get with DAYS360 unless you are displaying as an integer)? If so then YEARFRAC should give you the same result

=IF(B13="","",YEARFRAC($C$6,B13))

[you need Analysis ToolPak add-in enabled to use YEARFRAC inExcel 2003]

or if you only want the age as a number of years try DATEDIF

=IF(B13="","",DATEDIF(B13,$C$6,"y"))

Hello,

I have been using the very same file from a flash memory now, when trying to solve the issue - and
indeed this formula you gave gives different values on these different computers:

on one which calculates correctly:
=ISNUMBER(C6) GIVES "TRUE"
=ISNUMBER(C13) GIVES "FALSE"

So strangely enough, despite of the "FALSE" for C13 it gives the correct value for age.

on one which returns !ERROR#:
=ISNUMBER(C6) GIVES "FALSE"
=ISNUMBER(C13) GIVES "FALSE"

However, the date formats are (in both) English (UK) and the date format also the same.

Note, that even when I replace my formula with the correct one kindly provided by daddylonglegs, the outcome is (on both computers) as before: some computers calculate correctly, some other do not.

.... any hope still to solve the riddle???

Marjatta

Originally Posted by marjattanb

However, the date formats are (in both) English (UK) and the date format also the same.

are you talking about the cell formats on the worksheet or the regional settings on the computer

I think regional settings found in Control Panel..
just a hinch you have dates 4/5/1994 and formatting another one with 14.10.2013