Date & Time
All versions
◉ 39 views
=DAYS360()
The DAYS360 function returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=DAYS360(start_date,end_date,[method])
Hover argument names in the table for details.
Output typeNumber
Popularity15 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =DAYS360() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
start_date |
Date | Optional | occurs after |
end_date |
Date | Optional | , the |
dAYS360 |
Date | Optional | function returns a negative number. Dates should be entered by using the |
dATE |
Date | Optional | function, or derived from the results of other formulas or functions. For example, use DATE(2008,5,23) to return the 23rd day of May, 2008. Problems can occur if dates are entered as text. |
method |
Logical | Optional | A logical value that specifies whether to use the U.S. or European method in the calculation. FALSE or omitted = U.S. (NASD) method. If the starting date is the last day of a month, it becomes equal to the 30th day of the same month. If the ending date is the last day of a month and the starting date is earlier than the 30th day of a month, the ending date becomes equal to the 1st day of the next month; otherwise the ending date becomes equal to the 30th day of the same month.; TRUE = European method. Starting dates and ending dates that occur on the 31st day of a month become equal to the 30th day of the same month.. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
Dates |
A3 |
1-Jan-11 |
A4 |
30-Jan-11 |
A5 |
1-Feb-11 |
A6 |
31-Dec-11 |
A7 |
Dates |
A8 |
1-Jan-11 |
A9 |
30-Jan-11 |
A10 |
1-Feb-11 |
A11 |
31-Dec-11 |
Number of days between 1/30/2011 and 2/1/2011, based on a 360-day year.
=DAYS360(A3,A4)
Result:
1
Number of days between 1/1/2011 and 12/31/2011, based on a 360-day year.
=DAYS360(A2,A5)
Result:
360
Number of days between 1/1/2011 and 2/1/2011, based on a 360-day year.
=DAYS360(A2,A4)
Result:
30
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!