Manuals/calci/DAYS360

From ZCubes Wiki
Revision as of 06:31, 14 November 2013 by Jayaram (talk | contribs)
Jump to navigation Jump to search
DAYS360(sd,ed,lv)


  • where 'sd' is the starting date,'ed' is the end date and 'lv' is the logical value like true or false


Description

  • This function gives the number of days between given dates based on 360day year (30 days in 12 months).
  • Here SD and ED are the two dates to find the in between these two dates.
  • 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 false, then the result is based on the European method .
  • when we 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.


Examples

  • DAYS360("12/13/2013","1/13/2014",TRUE)=30
  • DAYS360("2/20/2013","3/3/2013",FALSE)= 13

See Also


References

Complex Numbers