Re-assigning weekend days in "Networkdays" Function

[sts75]

Hi everyone,

I would like some help on the "Networkdays" funtion. I need t
re-assign the default weekend days in this funtion (Saturday & Sunday
to Thursday & Friday.

For example:
note: date format is mm/dd/yy

=NETWORKDAYS(A1,A2)

where A1= 01/14/2004 (day being Saturday)
& A2=01/25/04 (day being Wednesday)

will return the value of 8 because it subtracts the 4 default weeken
days (2 Saturdays & 2 Sundays) automatically. I need it to return th
value 10 for the alternative 2 weekend days (1 Thursday & 1 Friday).

I want MS Excel to read Saturdays & Sundays as working days & Thrusday
and Fridays as the weekend days

 

[Frank Kabel]

Hi
try:
=NETWORKDAYS(A1+2,A2+2)

 

[sts75]

Thanks my friend, it worked :