Friday & Saturday

[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.

 

[Claus Busch]

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.

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


Regards
Claus Busch

 

[Omar]

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

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,

 

[Bernd P]

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,

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.

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