Share via

#NAME error using DAYS function on one computer but not another

Anonymous
2016-08-30T15:57:20+00:00

I used the DAYS() function to calculate the number of days between two dates which works fine on my computer. I sent the workbook to a colleague and he gets the #NAME error. Why would the function not work on his computer?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-30T16:28:02+00:00

    As far as I know, DAYS() function can be use from Excel 2013 to upper version 2016. Maybe this should be the reason. Your colleague maybe using Excel 2007 or 2010.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points
    2016-08-30T16:23:53+00:00

    DAYS was introduced in Excel 2013. When the workbook is opened in Excel 2010 or an older version, you'll see #NAME.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2016-08-30T16:24:26+00:00

    Is the Excel version on that computer different? The DAYS function is available in Excel 2013 and 2016.

    Was this answer helpful?

    0 comments