ellyzadg
Board Regular
- Joined
- May 9, 2016
- Messages
- 75
Hi guys!
Can you please help me to set an appropriate formula to get the number of working days based on the cut off dates. Below is the sample outcome. Thank you!
Set Cut off Date
[TABLE="width: 259"]
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]21-Dec-15[/TD]
[TD="align: center"]20-Jan-16[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]21-Jan-16[/TD]
[TD="align: center"]20-Feb-16[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]21-Feb-16[/TD]
[TD="align: center"]20-Mar-16[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]21-Mar-16[/TD]
[TD="align: center"]20-Apr-16[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]21-Apr-16[/TD]
[TD="align: center"]20-May-16[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]21-May-16[/TD]
[TD="align: center"]20-Jun-16[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]21-Jun-16[/TD]
[TD="align: center"]20-Jul-16[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]21-Jul-16[/TD]
[TD="align: center"]20-Aug-16[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]21-Aug-16[/TD]
[TD="align: center"]20-Sep-16[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]21-Sep-16[/TD]
[TD="align: center"]20-Oct-16[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]21-Oct-16[/TD]
[TD="align: center"]20-Nov-16[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]21-Nov-16[/TD]
[TD="align: center"]20-Dec-16[/TD]
[/TR]
</tbody>[/TABLE]
Selected Range Date : 01/25/2016 to 04/28/2016
Desired Output
[TABLE="width: 291"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: center"]From[/TD]
[TD="align: center"]TO[/TD]
[TD="align: center"]Workdays[/TD]
[/TR]
[TR]
[TD="align: center"]21-Dec-15[/TD]
[TD="align: center"]20-Jan-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Jan-16[/TD]
[TD="align: center"]20-Feb-16[/TD]
[TD="align: center"]20[/TD]
[/TR]
[TR]
[TD="align: center"]21-Feb-16[/TD]
[TD="align: center"]20-Mar-16[/TD]
[TD="align: center"]20[/TD]
[/TR]
[TR]
[TD="align: center"]21-Mar-16[/TD]
[TD="align: center"]20-Apr-16[/TD]
[TD="align: center"]23[/TD]
[/TR]
[TR]
[TD="align: center"]21-Apr-16[/TD]
[TD="align: center"]20-May-16[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]21-May-16[/TD]
[TD="align: center"]20-Jun-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Jun-16[/TD]
[TD="align: center"]20-Jul-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Jul-16[/TD]
[TD="align: center"]20-Aug-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Aug-16[/TD]
[TD="align: center"]20-Sep-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Sep-16[/TD]
[TD="align: center"]20-Oct-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Oct-16[/TD]
[TD="align: center"]20-Nov-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Nov-16[/TD]
[TD="align: center"]20-Dec-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Dec-16[/TD]
[TD="align: center"]20-Jan-17[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]
Can you please help me to set an appropriate formula to get the number of working days based on the cut off dates. Below is the sample outcome. Thank you!
Set Cut off Date
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]21-Dec-15[/TD]
[TD="align: center"]20-Jan-16[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]21-Jan-16[/TD]
[TD="align: center"]20-Feb-16[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]21-Feb-16[/TD]
[TD="align: center"]20-Mar-16[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]21-Mar-16[/TD]
[TD="align: center"]20-Apr-16[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]21-Apr-16[/TD]
[TD="align: center"]20-May-16[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]21-May-16[/TD]
[TD="align: center"]20-Jun-16[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]21-Jun-16[/TD]
[TD="align: center"]20-Jul-16[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]21-Jul-16[/TD]
[TD="align: center"]20-Aug-16[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]21-Aug-16[/TD]
[TD="align: center"]20-Sep-16[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]21-Sep-16[/TD]
[TD="align: center"]20-Oct-16[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]21-Oct-16[/TD]
[TD="align: center"]20-Nov-16[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]21-Nov-16[/TD]
[TD="align: center"]20-Dec-16[/TD]
[/TR]
</tbody>[/TABLE]
Selected Range Date : 01/25/2016 to 04/28/2016
Desired Output
[TABLE="width: 291"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: center"]From[/TD]
[TD="align: center"]TO[/TD]
[TD="align: center"]Workdays[/TD]
[/TR]
[TR]
[TD="align: center"]21-Dec-15[/TD]
[TD="align: center"]20-Jan-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Jan-16[/TD]
[TD="align: center"]20-Feb-16[/TD]
[TD="align: center"]20[/TD]
[/TR]
[TR]
[TD="align: center"]21-Feb-16[/TD]
[TD="align: center"]20-Mar-16[/TD]
[TD="align: center"]20[/TD]
[/TR]
[TR]
[TD="align: center"]21-Mar-16[/TD]
[TD="align: center"]20-Apr-16[/TD]
[TD="align: center"]23[/TD]
[/TR]
[TR]
[TD="align: center"]21-Apr-16[/TD]
[TD="align: center"]20-May-16[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]21-May-16[/TD]
[TD="align: center"]20-Jun-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Jun-16[/TD]
[TD="align: center"]20-Jul-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Jul-16[/TD]
[TD="align: center"]20-Aug-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Aug-16[/TD]
[TD="align: center"]20-Sep-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Sep-16[/TD]
[TD="align: center"]20-Oct-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Oct-16[/TD]
[TD="align: center"]20-Nov-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Nov-16[/TD]
[TD="align: center"]20-Dec-16[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]21-Dec-16[/TD]
[TD="align: center"]20-Jan-17[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]