WOrkday function - change working days

A

Ashutosh

How do I define working days as Monday to Saturday for the Workday function ?
( instead of standard Monday to Friday
 
B

Bob Phillips

=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)
 
A

Ashutosh

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.
 

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

How to implement two shifts per day with multiple teams 0
Workday function question 2
How do I use the WORKDAY function for a six-day working week? 12
Last workday 2
Help using the Workday Function 1
Calculate Future Date but don't want 6
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1

Top