Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1:  
<div style="font-size:30px">'''DAYS360(sd,ed,lv)'''</div><br/>
 
<div style="font-size:30px">'''DAYS360(sd,ed,lv)'''</div><br/>
   −
*where 'sd' is the starting date,'ed' is the end date and 'lv' is the logical value like true or false
+
*<math>sd</math> is the starting date
 
+
*<math>ed</math> is the end date
 +
*<math>lv</math> is the logical value like true or false
    
==Description==
 
==Description==
*This function gives the number of days between given dates based on 360day year (30 days in 12 months).
+
*This function gives the number of days between given dates based on 360 day year (30 days in 12 months).
*Here SD and ED are the two dates to find the in between these two dates.
+
*Here SD and ED are the two dates to find the in between days.
 
*LV is the logical value like TRUE or FALSE.  
 
*LV is the logical value like TRUE or FALSE.  
*When logical value is true , then the result  is based on U.S.method.
+
*When logical value is true, then the result  is based on U.S.method.
 
*when logical value is false, then the result is based on the European method .  
 
*when logical value is false, then the result is based on the European method .  
*when we not giving any logical values it will consider the U.S method.  
+
*when we are not giving any logical values it will consider the U.S method.  
*This function will give result as NAN , when the end date is before the starting date.  
+
*This function will give result as NAN, when the end date is before the starting date.  
     
writer
5,435

edits

Navigation menu