Calculates the number of days between two dates based on a 360-day year.
구문
DAYS360(start_date, end_date, [method])인수
start_date필수
The starting date of the period.
end_date필수
The ending date of the period.
method선택
A logical value that specifies whether to use the U.S. (NASD) or European 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")→30Calculates the difference between January 1st and February 1st, returning 30 days.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =DAYS360(start_date, end_date) and replace the arguments with your specific dates.
It uses a 360-day year convention (12 months of 30 days each) which is a standard in financial accounting.