Calculating number of days

**excelquestionz** · 05-06-2015, 01:51 PM

Is it possible to calculate the number of weekdays between two dates in excel by month? E.g. between April x and May y there were 8 weekdays in April and 3 weekdays in May.

Thanks!

**Ace_XL** · 05-06-2015, 01:55 PM

With start date in A1 and end date in A2 use

=NETWORKDAYS(A1,EOMONTH(A1,0))
&
=NETWORKDAYS(EOMONTH(A2,-1)+1,A2)

First formula gives weekdays in first month
Second formula gives weekdays in second month

**MarvinP** · 05-06-2015, 02:08 PM

Hi excelquestionz,

I think you can simply use NetWorkdays() function alone without needing to break how many in each month. What happens if your start and end dates span more than a few months? Perhaps then Ace_XL formulas will be needed. See the attached.