[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# MS Office 2013, Excel - Formula to determine the number of days between 2 datessubtract 2 dates

Posted on 2015-01-13
Medium Priority
226 Views
I want to determine the number of work days between 2 dates, the drop dead date and the current date.

I want to enter a drop date into a cell and have excel subtract the current date from whatever date is in that cell and display the number of workkday in another cell.

Example: Workdays  =  Drop dead date - Current date
Workdays =  Cell B2 - Current Date
Workdays  = April 1, 2015 - Jan 13, 2015
Workdays = 57

Thanks in advance for you assistance
Ldufresne
0
Question by:Lou Dufresne
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 24

Expert Comment

ID: 40546817
=b2-int(now)
0

LVL 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 40546867
NETWORKDAYS() will give the number of "working days" (i.e., Mon-Fri) between two dates.
0

LVL 1

Author Closing Comment

ID: 40546938
Patrick Mathews solution worked best for me.

Ldufresne19
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
###### Suggested Courses
Course of the Month12 days, 15 hours left to enroll