writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 54:
Line 54: − + − + − + − + − + − + − + + + + + + + +
→Examples
|}
|}
=YEARBASIS(A1,A3) : Calculates . Returns '''360''' as a result.
=YEARBASIS(A1,A3) : Calculates the number of days in the year for cell A1 for basis count 4. Returns '''360''' as a result.
=YEARBASIS(A2,A3) : Calculates . Returns '''360''' as a result.
=YEARBASIS(DATE(2014,1,1),0) : Calculates . Returns '''360''' as a result.
=YEARBASIS(A2,A3) : Calculates the number of days in the year for cell A2 for basis count 4. Returns '''360''' as a result.
=YEARBASIS(DATE(2014,1,1),1) : Calculates . Returns '''365''' as a result.
=YEARBASIS(DATE(2014,1,1),2) : Calculates . Returns '''360''' as a result.
=YEARBASIS(DATE(2014,1,1),0) : Calculates the number of days in the year for the specified date for basis count 0. <br/>Returns '''360''' as a result.
=YEARBASIS(DATE(2014,1,1),3) : Calculates . Returns '''365''' as a result.
=YEARBASIS(DATE(2014,1,1)) : Calculates with Basis omitted. Returns '''360''' as a result.
=YEARBASIS(DATE(2014,1,1),1) : Calculates the number of days in the year for the specified date for basis count 1. <br/> Returns '''365''' as a result.
=YEARBASIS(DATE(2014,1,1),2) : Calculates the number of days in the year for the specified date for basis count 2. <br/> Returns '''360''' as a result.
=YEARBASIS(DATE(2014,1,1),3) : Calculates the number of days in the year for the specified date for basis count 3. <br/> Returns '''365''' as a result.
=YEARBASIS(DATE(2014,1,1)) : Calculates the number of days in the year for the specified date. Here basis count is omitted. <br/> Returns '''360''' as a result.
==Related Videos==
==Related Videos==