Ohne dich ist alles doof...<3title> <style> body { scrollbar-face-color:#000000 scrollbar-highlight-color: #ffffff; scrollbar-3dlight-color: #ffffff; scrollbar-darkshadow-color:#ffffff ; scrollbar-shadow-color:#ffffff; scrollbar-arrow-color: #ffffff; scrollbar-track-color: #ffffff; </style> <style type="text/css"> <!-- a:link { color: #000000; cursor:default; text-decoration: underline} a:visited { color: #000000; cursor:default; text-decoration: underline } a:active { color: #000000; cursor:default; text-decoration: none} a:hover {color: #000000; cursor:default; text-decoration: blink} .Stil1 {color: #000000} --> </style> <style> <!-- b {color:#000000;} i {color:#000000;} u {color:#000000;} --> </style> <style> a { color: #ffffff; } TEXTAREA { Color: 000000; Background-Color:#ffffff; Font-Family: BlackChancery; Font-Size: 7pt; Border: 1px solid 000000; } INPUT { Color:#000000; Background-Color: #ffffff; Font-Family: BlackChancery; Font-Size: 7pt; Border: 2px solid #000000; } .navi { color: #000000; } </style> <style type="text/css"> .inhaltetable { width:423; } </style> <style type="text/css"> TEXTAREA { width: 270; height: 144;} --> </style> <style type="text/css"> INPUT{ width: 100; height: 18;} .Stil2 {color: #000000} --> </style> </head> <body bgcolor="#ffffff" topmargin="0" leftmargin="0" text="#FFFFFF"> <img border="0" src="http://www.beepworld.de/memberdateien/members89/kiwicop16/ohnedichisallesdoof.jpg" scroll="no" bgproperties= "fixed" align="left" width="990",height="0" style="position:absolute; top:0; left:0;" > <div class="Stil1" style="overflow:auto; position: absolute; width:480px; height:350px; left:420; top:35px"> <font face="Tahoma, Arial, Verdana" size="1" color="#000000"> <table class="inhaltetable" border="0" width="480" cellspacing="1" cellpadding="3"> <tr> <td width="100%"> <font face="Tahoma, Arial, Verdana" size="1" color="#000000"> <b>MS Excel Tips: Chose the Contrast between Two Dates Using DATEDIF</b> <br /> <br /> <div align="justify">This is the little known function in Score well in the past few years even though it has become to be found in all versions since 95, this will make it documented only inside the Help file of 2000 but no further documentation from it in a different other versions.<br>Nevertheless this function is mighty useful for calculating an employees age, period of service and the length or length of a borrowing arrangement.<br>This Excel function actually means DATED DIFFERENCE, ie it finds the real difference between two dates. The dates is usually calculated in many variables, that is year, month, day or hours.<br>The strategy to work with this function <a href="http://www.test4prep.com/642-874.html">Cisco 642-874</a> or it's syntax is usually as follows<br>=DATEDIF (Date1, Date 2,Interval)<br>Where<br>Date1 is definitely the first date<br>Date2 is the second date<br>Interval is definitely the type of interval to come back i.e days, months, years<br><br>There many codes to insert to the function for your date interval and yours should be one of the below:-<br>m = months (complete calendar months regarding the two dates)<br>d = days (number of days between your two dates)<br>y = years ( variety of complete calendar years between the two dates<br>ym = calendar months between the dates just as if we were looking at in the same year<br>yd = complete calendar days relating to the dates as if within the same year<br>md = complete calendar days between the dates just as if these people were while in the same month and year.<br><br>Here is actually a basic example<br>To calculate the capacity of service for the exmployee<br>In cell A1 type 01/12/1990<br>In cell B1 type 15/11/2010<br>In cell A5 type the formula =DATEDIF(A1,B1,"Y")<br>Your result will probably be 19.<br>A few points to note<br>If the interval you stated isn't one of several above options then Excel will return the #NUM error.<br>If Date 1 is later than Date 2 Excel will return the #NUM error.<br>If Date 1 or Date 2 isn't a valid date then a Excel will return the #VALUE error.<br>If such as the Interval string i.e Y, M D etc directly within the formula then you'll need to surround it in double quotes "".<br><br>If you have the interval in another cell i.e =DATEDIF(A1,B1,C2)<br><br>Let's get there the degree during this. For the amount of service of your employee you will normally want to find out the times, months <a href="http://www.test4prep.com/642-902.html">Cisco 642-902</a> and a lot of service, the formula would look like this:-<br>=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months"&DATEDIF(A1,B1,"md")&" Days"<br>The bring about this instance can be 19 Years, 11 Months and 14 Days. However, but if your outcome of the formula includes a zero like 0 Years, 14 Months and a pair of Days then you certainly may wish to suppress your zeros which means you have the result 14 Months and also Days only.<br>Again after a little tweaking with the formula we are able to accomplish that by adding in the sneaky IF statement whilst your formula would seem like this:-<br>=IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",<br>DATEDIF(A1,B1,"ym")&" months ")&DATEDIF(A1,B1,"md")&" days"<br>A great formula- give this particular one a try.<br> </font> </td> </tr> <tr> <td width="100%"> <table border="0" style="BORDER-TOP: #f2f2f2 1px dotted;" width="100%" cellspacing="3"> <tr> <td> <font face="Tahoma, Arial, Verdana" size="0" color="#000000"> <i>2.10.12 12:58</i><br>  </font> </td> <td> <font face="Tahoma, Arial, Verdana" size="0" color="#000000"> <div align=right><a href="http://stewert.myblog.de/stewert/art/7010128/MS-Excel-Tips-Chose-the-Contrast-between-Two-Dates-Using-DATEDIF">verlinken</a><br> </div> </td> </tr> </table> </td> </tr> <tr> <td width="100%"> Letzte Einträge: <a href="http://stewert.myblog.de/stewert/art/7009900/MS-Excel-Tips-Use-Conditional-Formatting-To-search-out-Duplicate-Data">MS Excel Tips - Use Conditional Formatting To search out Duplicate Data</a>, <a href="http://stewert.myblog.de/stewert/art/7010356/MS-Excel-Tutorial-Creating-And-making-use-of-Named-Ranges">MS Excel Tutorial - Creating And making use of Named Ranges</a>, <a href="http://stewert.myblog.de/stewert/art/7010584/MS-Excel-Tutorial-How-to-operate-the-Concatenation-Function-In-Excel">MS Excel Tutorial - How to operate the Concatenation Function In Excel</a>, <a href="http://stewert.myblog.de/stewert/art/7010812/My-Top-iPad-VPN-Accessories-for-Business">My Top iPad VPN Accessories for Business</a>, <a href="http://stewert.myblog.de/stewert/art/7011040/Nearshore-Software-Developers-Five-Compelling-Reasons-to-Use-Them">Nearshore Software Developers - Five Compelling Reasons to Use Them</a> </td> </tr> </table> </center> Hier kommt später eurer Text hin..den hier abba entfernen... steht da sonst auch... Und die hilfen auch....</div> <div style="overflow:auto; position: absolute; width:130px; height:300px; left:35px; top:20px"> <font size="3"><span class="Stil1"><b></b> <br> <span class="Stil2"><u><b>Bloq:</u></b><p> <a href="http://www,myblog.de/dein bloqname">Home</a><br> <a href="http://www.myblog.de/name">Gb</a><bR> <a href="http://www.myblog.de/name">Kontakt</a><br> <a href="http://www.myblog.de/name">Old</a><br> <a href="http://www.myblog.de/">Myblog</a><br> <a href="http://link">~*Kiwic♥p*~</a> <p><u><b>Other:</u></b><p> <a href="">Link</a><br> <a href="">Link</a> </font><font size="3"></font> </div> </body> Gratis bloggen bei<br /><a href="http://www.myblog.de">myblog.de</a><div id="end-of-ads"><p align="center"><script type="text/javascript">try { hmGetAd({s:'300x250'}); } catch(a) {}</script></p></div> </html>