I'm currently revamping our sickness spreadsheet at work. We report the number of sick days by month. So with the NETWORKDAYS formula I can count the number of days between 2 dates, minus weekends and bank holidays which is fantastic. But as we report by month how can I make it only count the network days in a specific month? For example if someone is off sick between the dates of 16/04/2012 and 25/05/2012, I would want one cell to calculate the number of network days in April and one cell to calculate the number of network days in May (I will have this for all the months in the year).