Using the following formula: =MAX(0,MIN(EOMONTH(E$19,0),$B24)-MAX(E$19,$A24)+1)

I can calculate between a start and end date but gives me the days of each month.

Start Date End Date Jan Feb Mar Apr May
1/31/14 2/11/14 1 11 0 0 0
2/17/14 2/19/14 0 3 0 0 0
3/14/14 5/9/14 0 0 18 30 9

I actually just want to calculate the week days or work days. At the moment it is calculating all the days in that month.