Manuals/calci/DAYS360
DAYS360(sd,ed,lv)
- 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 sd} is the starting date
- 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 ed} is the end date
- is the logical value like true or false
Description
- This function gives the number of days between given dates based on 360 day 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 sd} 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 ed} 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 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 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.
Examples
- DAYS360("12/13/2013","1/13/2014",TRUE)=30
- DAYS360("2/20/2013","3/3/2013",FALSE)= 13
See Also