How do I modify the default working days in excel

G

Guest

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

How do I do that
 
H

HiArt

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
 

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

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

Top