I'm using networkdays(), however it is excluding two days out of the seven. Is there a formula to exclude only the Sunday.
Thanks.
I'm using networkdays(), however it is excluding two days out of the seven. Is there a formula to exclude only the Sunday.
Thanks.
in Excel 2010 use NETWORKDAYS.INTL
Hence
=NETWORKDAYS.INTL(start date,end date,11)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks