Hi Suresh

The syntax for NETWORKDAYS() do not provide a customization on the weekdays
straightaway. The below formula use WEEKDAY() function to get the number of
working days (inclusive of start and end days) excluding Friday and Saturdays

A1 = start date
B1 = end date

=SUMPRODUCT(INT((B1-A1+WEEKDAY(A1-{1,2,3,4,5}))/7))

The days to be counted are mentioned in the array {1,2,3,4,5}. To count Sat
and Sun add the day numbers {6,7}

If this post helps click Yes
---------------
Jacob Skaria


"Suresh" wrote:

I want to use the Networkdays function to get the working days between two
dates. But in my case I want to make Firday and Saturday as weekend rather
than Saturday and Sunday. Is it possible.

Thanks!