saturdays

Hi All, Would like to ask for your assistance on this if statement.J2 and H2 are 2 different dates. How do I count the difference(remaining days) without including saturdays and sundays? =IF(AND(M2="NA",I2="No"),0,IF(AND(I2="Yes",J2=0),NOW()-H2,J2-H2)) Thank you Bryan

I'm looking to calculate the days of the week between 2 sets up days, while not factoring in Saturdays. For example below (with service days being the result): <colgroup><col span="2"><col></colgroup><tbody> A B Service Days 30-May 3-Jun 3 </tbody>

Dear friends, I have made a salary sheet. This sheet has the months & dates which changes as per the selection of the month. I am facing a couple of problems. 1. How to calculate 1st, 3rd & 5th Saturdays for the working Saturdays. Rest of the Saturdays are holidays with all the Sundays as...

I have a simple Spreadsheet with 3 Columns,"Date, Revenue and Cost." I have highlighted the 3 Columns as my Data for the Graph. I have deleted all the Rows that would be Saturday or Sunday. So column A has Jan 1-5, there is no Jan 6 or 7 and then picks up with Jan 8. However, the Bar Graph...

Hi, I have never worked on workdays before so I do not know most of the available formula and play around. So I am taking this shortcut of asking you guys. I googled across and found this one: http://www.excelbanter.com/showthread.php?t=91820 Where Bob has given an ARRAY formula. Following is...