Formula that can exclude Sat and Sun

[ahsohz]

Hi,

Is there any formula that can help to exclude Sat and Sun in a month?

Thank you

 

[Bob Phillips]

Here is the help details on the NETWORKDAYS function

Returns the number of whole working days between start_date and end_date.
Working days exclude weekends and any dates identified in holidays. Use
NETWORKDAYS to calculate employee benefits that accrue based on the number
of days worked during a specific term.

If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu.

Syntax

NETWORKDAYS(start_date,end_date,holidays)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ahsohz]

Hi Bob,

Thanks for the help. I am able to do it now.