ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Error message #NAME from formula (https://www.excelbanter.com/excel-worksheet-functions/82003-error-message-name-formula.html)

JDub

Error message #NAME from formula
 
I have a the formula "YEARFRAC" on one of my spreadsheets to calculate the
length of time between two dates. When I look at the spreadsheet on my
computer, the formula displays the correct answer, and also does so on most
of my co-workers computers. However, for on co-worker, she gets the error
"#NAME." I think it is a setting on her computer, but cannot find one. Any
ideas, or am I missing the setting?

Thanks!
Josh


Duke Carey

Error message #NAME from formula
 
from Excel's help file - notice the part about the #Name error?

YEARFRAC
Calculates the fraction of the year represented by the number of whole days
between two dates (the start_date and the end_date). Use the YEARFRAC
worksheet function to identify the proportion of a whole year's benefits or
obligations to assign to a specific term.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


"JDub" wrote:

I have a the formula "YEARFRAC" on one of my spreadsheets to calculate the
length of time between two dates. When I look at the spreadsheet on my
computer, the formula displays the correct answer, and also does so on most
of my co-workers computers. However, for on co-worker, she gets the error
"#NAME." I think it is a setting on her computer, but cannot find one. Any
ideas, or am I missing the setting?

Thanks!
Josh



All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com