Difference Between Two Dates in Banker’s Units (DAYS360)
Syntax: DAYS360(t1; t2; Year_Type)
The DAYS360 function calculates the number of days between two dates given as timestamps, in banker’s years. For example:
=DAYS360(DATE(2010; 1; 15); DATE(2010; 6; 1); 0)
returns 136.
You can give DAYS360 the date in a more natural format:
=DAYS360("1/15/2010"; "6/1/2010"; 0)
Figure 12-14. Sample result of the DAYS360 function
The banker’s year has 12 months of 30 days each giving a total of 360 days in a year. It was, and sometimes still is, used before banks started using computers. It simplifies calculations when they are done by hand, but it ...
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
