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

[Simon DR]

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]

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

 

[Duke Carey]

or perhaps the WORKDAY() function