Formula help

[markster]

Hi everyone

I need to calculate the number of working days (Monday to Friday) between 2 dates. So I know how to calculate the number of days between 2 dates i.e. date -date. How do I amend so it only counts the number of Monday to Friday days between the 2 dates?

So my formula will always be Today()-Cell Reference (containing a date). I need the number of days to look at the today date (start date) and end date (date in cell) and work out number of Monday to Friday days. Also it needs to include the start date and end date in it's count because if I do a formula today() (27/11) - cell containing 23/11 it will count this as 4 days not 5). Hope this makes sense.

Thanks
Mark

 

[arthurbr]

Have a look at the NETWORKDAYS function ( and add 1 to the result)
OR NETWORKDAYS.INTL function

 

[markster]

Thanks very much mate.