WOrkday function - change working days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I define working days as Monday to Saturday for the Workday function ?
( instead of standard Monday to Friday
 
=WORKDAY(start_date,days)-SUMPRODUCT(--(WEEKDAY(ROW(INDEX($1:$65536,start_da
te,1):INDEX($1:$65536,WORKDAY(start_date,days),1)))=1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
I am not exactly sure what do I replace start_date and days with. If I
replace start date with the date I want to start with and number of days as
how many working days to add, it does not skip sundays.
 
You must log in or register to reply here.

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

Workday function question 2
How do I use the WORKDAY function for a six-day working week? 12
Last workday 2
Calculate Future Date but don't want 6
Calculate workdays for irregular work patterns 1
Workday - Saturdays Included - Holidays Excluded 1
How to calculate the number of Workdays for irregular work pattern 1
Friday as weekend in Workday Function 6

Back
Top