Share via

Networkdays() function

Anonymous
2020-08-18T22:14:18+00:00

I am trying to use the NETWORKDAYS(Start_Date, End_Date, [holidays]) function to output how many days are left between today's date and a deadline. It keeps returning a date stamp like "1/10/1900." However, I simply want the total number of days. 

For example:

Col A has the deadline: 08/31/2020

Today's date is 08/18/2020

My function for column B is: = NETWORKDAYS(TODAY(),A1)

The output is then "1/10/1900."

My intended output is either 9 or 10. Including or excluding the current working day is not important to me.

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-08-18T22:48:06+00:00

    Hi Bryan,

    Thank you for reaching out to us. I am Thuy, an Independent Advisor and Microsoft user like you.

    For this task, what you need to do is formatting cells in column B as "General". Currently as you might format them as "Date" then it returns unexpected result.

    Hope this helps and please let me know if you need more assistance.

    Regards

    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2020-08-18T22:23:25+00:00

    Hi,

    Format the cell as number.

    0 comments