MS Office 2013, Excel - Formula to determine the number of days between 2 datessubtract 2 dates
Posted on 2015-01-13
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
Please advise what formula to use .
Thanks in advance for you assistance