Friday & Saturday

  • Thread starter Thread starter Omar
  • Start date Start date
O

Omar

Dear all,
How can I let Excel knows that Friday & Saturday are the weekend, or
our workdays (Sunday to Thursday). I am using Excel 2007.
Many thank in advance.
 
Hi Omar,

Am Tue, 27 Jul 2010 23:54:43 -0700 (PDT) schrieb Omar:
How can I let Excel knows that Friday & Saturday are the weekend, or
our workdays (Sunday to Thursday). I am using Excel 2007.
Many thank in advance.
Click to expand...

your dates in A1:A30, then
=SUMPRODUCT(--(WEEKDAY(A1:A30)<6))


Regards
Claus Busch
 
Hi Omar,

Am Tue, 27 Jul 2010 23:54:43 -0700 (PDT) schrieb Omar:


your dates in A1:A30, then
=SUMPRODUCT(--(WEEKDAY(A1:A30)<6))

Regards
Claus Busch
Click to expand...

Dear helper,
What I need to do is to find the number of workdays (Sunday through
Thursday) between two dates by using NETWORKDAYS function; normally
Excel excluding Saturday & Sunday as weekends, I need Excel excluding
Friday & Saturday.
Regards,
 
Dear helper,
What I need to do is to find the number of workdays (Sunday through
Thursday) between two dates by using NETWORKDAYS function; normally
Excel excluding Saturday & Sunday as weekends, I need Excel excluding
Friday & Saturday.
Regards,
Click to expand...

Why MUST you use the NETWORKDAYS formula?  Did you try Claus's
formula?  It will give you exactly what you requested.

If you want to enter just two dates, instead of a range,

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(StartDate&":"&EndDate)))<6))

If you MUST use the NETWORKDAYS formula, then try:

=NETWORKDAYS(StartDate+1,EndDate+1)

However, if you are going to use the optional [holidays] argument,
then you should try:

This formula must be **array-entered**:

=NETWORKDAYS(StartDate+1,EndDate+1,Holidays+1)
----------------------------------------
To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl><shift> while hitting <enter>.  If you did this
correctly, Excel will place braces {...} around the formula.
Click to expand...

Hello,

A direct and non-volatile approach is to subtract the number of
Fridays and Saturdays from the total number of days:
Please see the first formula on
http://sulprobil.com/html/date_formulas.html

Regards,
Bernd
 
Back
Top