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

G

Guest

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)
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to tell day of week 2
Friday as weekend instead of Saturday & Sunday 3
Calculate the number of days to exclude Sunday & Holidays 6
how to set a 6-day work week ? 2
can excel schedule a six day work week? 3
Future date with six day week including holidays 1
How do I calculate future date after number of days 1
SUM/ Count Only weekdays 2

Top