Difference between revisions of "Manuals/calci/DAYS360"

From ZCubes Wiki
Jump to navigation Jump to search
Line 26: Line 26:
 
==See Also==
 
==See Also==
 
*[[Manuals/calci/DATE  | DATE]]
 
*[[Manuals/calci/DATE  | DATE]]
*[[Manuals/calci/DAYS | DAYS]]
+
*[[Manuals/calci/DAY | DAY]]
  
 
==References==
 
==References==
 +
*[http://en.wikipedia.org/wiki/360-day_calendar| 360 DAYS]

Revision as of 03:29, 18 April 2014

DAYS360(startdate,enddate,method)


  • Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle startdate} is the date from which date counting have to start.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle enddate} is the ending date of the counting.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle method} is the logical value either true or false.

Description

  • This function gives the number of days between given dates based on 360 days in a year. (30 days in 12 months).
  • Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle startdate} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle enddate} are the two dates to find the in between days.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle method} 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 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.

ZOS Section

  • The syntax is to calculate DAYS360 in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DAYS360(startdate,enddate,method)} .
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle startdate} is the date from which date counting have to start.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle enddate} is the ending date of the counting.
  • Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle method} is the logical value either true or false.
  • For e.g.,DAYS360("10/30/2010","6/15/2016",TRUE) = 2025.

Examples

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

See Also

References