DATE+&+NETWORKDAYS+Functions

Lets say you want to know how many days you will be working in the month of November, you can use the DATE and NETWORKDAYS function to easily figure it out: -First, in cell A1, you will use the DATE function to enter in the first day of November, or DATE(2009,11,1). -Next, in cell A2 you will use the DATE function again to enter in the last day of November, or DATE(2009,11,30). -After that, in cell A3, A4 and on, depending on how many you choose to include, you will enter in each holiday you take off of work using the DATE function each time. For example, lets say you just take off for Thanksgiving and the day after, in cell A3 you would enter DATE(2009,11,26) and in cell A4 you would enter DATE(2009,11,27). -Last, in cell A5, you will use the NETWORKDAYS function to calculate the total number of days you worked in November by putting the start date first, then the end date, and finally the two vacation days. For example, =NETWORKDAYS(A1,A2,A3:A4). Once calculated, you should end up with 19 days.

-Christina Casaburi