Excel 2010 has the functions around the week revised. An additional parameter ensures that after ISO standard is being worked on. The new functions Net working days, intl and Working day intl should one with the new parameter Weekend Trip to help. The problem that the week with the January 1 also as automatically the first calendar week output can thus be solved using combinations.
Net working days.intl ()
If you call the new function in Excel 2010 Net working days, intl on, results in the following View:
The one marked in red is new here Parameter Weekend Trip. From the below listed Table can be accessed by entering certain Weekend numbers can Weekend days hold tight.
In the same input field, you can also use a specific string individual Weekend days define. That means it is possible, too three or More Days as Weekend days to be determined. For example, you give 0000000 one, has mine save Weekend days. To give 1111111 a, sets the function Days as a Weekend days fixed. For a declaration of a Installations, Wednesdays and Fridays the input is therefore as weekend days 1010100 necessary. There are seven digits for seven days of the week beginning with Monday. A 1 activates and a 0 deactivates the respective day.
Workdays.intl ()
The second new function looks almost identical Working day intl .
Perhaps one or the other will find out about the output of the Formula result wonder. In this case it would be the 40408. This number combination stands for the 18.08.2010 and is as text formatted. The best way to do this is to let the results in directly from Excel Date format.
Attention
You should be careful if you also use the version of a workbook created with Excel 2010 2007 would like to edit. Under the function there is a category with the name Compatibility. All formulas are listed there that can also be further processed with Excel 2007 without the error #Surname in a Formula cell shows up.
| Transparency: | This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de. |
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille
Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.