Calculates the number of days between two dates based on a 360-day year.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
DAYS360(start_date, end_date, [method])The DAYS360 function is commonly used in accounting and financial calculations where a 360-day year is standard. It treats every month as having 30 days, which helps simplify interest calculations for financial models.
=DAYS360("2023-01-01", "2023-02-01")결과: 30
Calculates the difference between January 1st and February 1st, returning 30 days.
It uses a 360-day year convention (12 months of 30 days each) which is a standard in financial accounting.