Include weekends in TRUE FALSE FUNCTION

[Andreja]

Thank you first to anyone who is able to help me!
I use the following function e.g. to capture the gap between dates. But the problem I have I want them to discount weekends. e.g. if a paper is received on Friday 20/5/11 I want the calculation to take into account that the 21 and 22/5/11 are to be excluded.

a) I have a date when we receive a paper, so a date is inserted
b) That date needs marry up from the deadline we are suppose to action that piece of paper e.g. 1= 24 hours and 2= 24hours
c) So a TRUE and FALSE argument is enforced (to do the number crunch)
e.g. =IF(K20>1,"TRUE","FALSE")
but I want weekends to be taken taken into consideration.

Please get back to me if I am unclear.
Basically I want the '0' below to not include dates relating to Saturday or Sunday. Sorry for going on as I hope to hear from someone soon.

J

<TABLE style="WIDTH: 394pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=524 border=0 x:str><COLGROUP><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4132" width=113><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4132" width=113><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><TBODY><TR style="HEIGHT: 25.5pt" height=34><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 85pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: #ccffcc" align=right width=113 height=34 x:num="1.1">1.1</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=75>No. Days</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 55pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=73>Overdue Y/N</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 85pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" align=right width=113 x:num>1.2</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=74>No. Days</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" width=76>Overdue Y/N</TD></TR><TR style="HEIGHT: 204.75pt" height=273><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 85pt; BORDER-BOTTOM: #ffe9d2; HEIGHT: 204.75pt; BACKGROUND-COLOR: #ccffcc" width=113 height=273>Section Papers received in MHA Office</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: #ffe9d2; BACKGROUND-COLOR: yellow" width=75>PLEASE NOTE: DAY SHALL APPEAR WHEN START DATE IS INSERTED</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 55pt; BORDER-BOTTOM: #ffe9d2; BACKGROUND-COLOR: yellow" width=73>MHA OFFICE TO IGNORE - See Formula Ref. for Guidance</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 85pt; BORDER-BOTTOM: #ffe9d2; BACKGROUND-COLOR: yellow" width=113>Scrutiny by MHA Staff member (Include Senior Scrutiny)</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 56pt; BORDER-BOTTOM: #ffe9d2; BACKGROUND-COLOR: yellow" width=74>PLEASE NOTE: DAY SHALL APPEAR WHEN START DATE IS INSERTED</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: #ffe9d2; BACKGROUND-COLOR: yellow" width=76>MHA OFFICE TO IGNORE - See Formula Ref. for Guidance</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #ccffcc" align=right height=17 x:num="40641">08/04/2011</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" align=right x:num x:fmla="=A3-A3">0</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:fmla='=IF(B3>1,"TRUE","FALSE")'>FALSE</TD><TD class=xl74 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" align=right x:num="40641">08/04/2011</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" align=right x:num x:fmla="=(D3-A3)">0</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow" x:fmla='=IF(E3>1,"TRUE","FALSE")'>FALSE</TD></TR></TBODY></TABLE>

 

[AlphaFrog]

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.