How do I modify the default working days in excel

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

Guest

I need to set the weekend days to Thursday & Friday instead of Saturday &
Sunday in Excel.

How do I do that
 
Not easy.

Either write your own User-defined Function to do this

or

use WorkDays function setting every Thursday and Friday as a holiday.

HTH

Art
 
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

Re-assigning weekend days in "Networkdays" Function 2
Average of last 30 days 9
Formula for adding a day to a particular date. 1
Shift Schedule Formula 1
Easy question (just not for me) 2
How do I count repeat Occurrences 5
Friday & Saturday 3
Changing Weekend 6

Back
Top