"I need to calculate the elapsed days between two dates Is there a function that compute?"
No problem. Resolve this issue with the according NETWORKDAYS
from the following example:
We want in C6 cell displayed the difference working days elapsed between the start date indicated in cell C2 and the end date indicated in cell C4. Applying the function NETWORKDAYS the solution is simple.
Note: NETWORKDAYS function not provided by default in category Date and Time Excel (in versions prior to Excel 2007). To add must do the following: Go to menu Tools / Add and activate the checkbox Tools analysis. Click OK and new features, including the present one, will appear in different categories.
The syntax of this function is:
= NETWORKDAYS (Start Date, End , Holidays)
is important stressed that the role NETWORKDAYS considered on Saturdays and Sundays as non-working. On the other hand, v masters need a list of holidays for the period analyzed. In our example, we introduced a list of the holidays in 2009 and 2010 (schedule to be updated and supplemented by local holidays):
To excel incorrectly warn us if we introduce a date we will use the tool Data Validation and the logic function SI .
1. Select the range B16: B38 and give the name Events (click on the name-box to the left of the formula bar, and typing the name directly and then pressing Enter )
2. We are located in cell C6 and type the formula:
3. We are located in cell C4 and go to menu Data / Validation and perform the configuration shown in the following images:
Thus in addition to obtaining the calculation were looking for:
If a wrong final date excel warn us:
0 comments:
Post a Comment