Excel 2007 : Converting days to working days

**poboy2214** · 02-18-2010, 01:13 PM

I am trying to track how many days from when we receive a submittal to when it is sent back out again. The simple formula is to subtract the column with the sent date from the received date, but I want it to take into account weekends (when we don't work). Is there a way to do this?

**royUK** · 02-18-2010, 01:17 PM

Take a look at the NETWORKDAYS Function

**zbor** · 02-18-2010, 01:17 PM

tRY =NETWORKDAYS(A1,A2,[holidays])

**Ron Coderre** · 02-18-2010, 01:18 PM

The NETWORKDAYS function, which is native in XL2007, will do what you want.
It can even take holidays into consideration.

Does that help?

**poboy2214** · 02-18-2010, 01:22 PM

Thanks, that worked well

**royUK** · 02-18-2010, 01:22 PM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save