ExcelBanter - how do i sum day of the week without counting sats and sundays?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i sum day of the week without counting sats and sundays? (https://www.excelbanter.com/excel-worksheet-functions/62110-how-do-i-sum-day-week-without-counting-sats-sundays.html)

Simon DR

how do i sum day of the week without counting sats and sundays?

how do i sum day of the week without counting sats and sundays?...this is a
function that lotus 123 have the function is for example
@workday(a11,5,fiesta)

Duke Carey

how do i sum day of the week without counting sats and sundays?

Make sure you have the Analysis Toolpak installed (Tools-Addins) then use
=NETWORKDAYS()

"Simon DR" wrote:

how do i sum day of the week without counting sats and sundays?...this is a
function that lotus 123 have the function is for example
@workday(a11,5,fiesta)

Duke Carey

how do i sum day of the week without counting sats and sundays?

or perhaps the WORKDAY() function

"Simon DR" wrote:

how do i sum day of the week without counting sats and sundays?...this is a
function that lotus 123 have the function is for example
@workday(a11,5,fiesta)

All times are GMT +1. The time now is 02:14 PM.