How do I set up a 5 day calendar with Thursday and Friday weekend.

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

Guest

How do I calculate days between dates using a 5 day calendar with Thursday
and Friday as the weekend days? Thank you.
 
Hi
try
=NETWORKDAYS(A1+1,A2+1)

where A1 and A2 are your two starting days
 
Hi, Frank:

I think you need to add 2, so Excel will "think" that Thu is Sat, and Fri is
Sun.
 
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

Build a calendar except weekends 5
date to show then end of the week 2
How do I modify the default working days in excel 1
Week Ending data 2
Re-assigning weekend days in "Networkdays" Function 2
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Formula for adding a day to a particular date. 1
Average of last 30 days 9

Back
Top