Dates Calculation

[zaska]

Hi,

I would like to know the differnce between Two dates in the following Example.

I would like to display weekdays if difference is due on Saturdays and Sundays.


<table border="0" cellpadding="0" cellspacing="0" width="459"><col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:4827;width:99pt" width="132"> <col style="mso-width-source:userset;mso-width-alt:5046;width:104pt" width="138"> <col style="mso-width-source:userset;mso-width-alt:4242;width:87pt" width="116"> <tbody><tr style="height:15.0pt" height="20"> <td class="xl71" style="height:15.0pt;width:55pt;font-size: 9.0pt;color:windowtext;font-weight:700;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Tahoma;border:.5pt solid windowtext; background:#FFC000;mso-pattern:black none" height="20" width="73">Date</td> <td class="xl72" style="border-left:none;width:99pt;font-size:9.0pt; color:windowtext;font-weight:700;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Tahoma;border:.5pt solid windowtext; background:#FFC000;mso-pattern:black none" width="132">Amount Collected</td> <td class="xl73" style="border-left:none;width:104pt;font-size:9.0pt; color:windowtext;font-weight:700;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Tahoma;border:.5pt solid windowtext; background:#FFC000;mso-pattern:black none" width="138">Amount Deposited</td> <td class="xl74" style="border-left:none;width:87pt;font-size:9.0pt; color:windowtext;font-weight:700;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:Tahoma;border:.5pt solid windowtext; background:#FFC000;mso-pattern:black none" width="116">Deposited date</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none" height="20">01-09-2011</td> <td class="xl65" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none">200 </td> <td class="xl64" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none"> </td> <td class="xl69" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20">02-09-2011</td> <td class="xl65" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none">300 </td> <td class="xl64" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none">200</td> <td class="xl70" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none">03-09-2011</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none" height="20">03-09-2011</td> <td class="xl65" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none">400 </td> <td class="xl64" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none">300</td> <td class="xl70" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#B8CCE4;mso-pattern:#B8CCE4 none">05-09-2011</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl75" style="height:15.0pt;border-top:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#DCE6F1;mso-pattern:#DCE6F1 none" height="20">04-09-2011</td> <td class="xl76" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#C5D9F1;mso-pattern:black none"> </td> <td class="xl77" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#C5D9F1;mso-pattern:black none"> </td> <td class="xl78" style="border-top:none;border-left:none;font-size:11.0pt; color:black;font-weight:400;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border:.5pt solid windowtext; background:#C5D9F1;mso-pattern:black none"> </td> </tr> </tbody></table>

Thank you

 

[Gerald Higgins]

Hi. It's not clear what you want exactly. Can you explain in more detail please ? In your example, what exactly do you want the results to be ?

 

[zaska]

Sorry my question was vague

What ever cash is collected today will be deposited in the bank the very next day but there will be no cash deposits on saturdays and sundays

Here i would like to know by how many days the deposits were delayed and ignore the same if it was on account of saturday and sunday.

The formula should indicate that the dealy is because of saturday / sunday

Thank you

 

[xenou]

NetWorkingDays() Formula should work I guess:
http://office.microsoft.com/en-us/excel-help/networkdays-HP005209190.aspx

 

[zaska]

Thank you i will go through it.