How to How to Use DAYS360 Function in Excel in Excel - Practical Guide

Learn how to use the DAYS360 function to calculate the number of days between two dates using a 360-day year basis. This function is essential for financial calculations, bond yields, and accounting systems that use the 30/360 day-count convention, simplifying complex date arithmetic in Excel.

Why This Matters

Financial professionals rely on DAYS360 for accurate bond interest calculations and compliance with standard accounting conventions. Mastering this function ensures precise date-based financial computations in banking and investment sectors.

Prerequisites

•Basic Excel navigation and cell selection
•Understanding of date formats in Excel
•Familiarity with formula syntax and function structure

Step-by-Step Instructions

Open Excel and Prepare Your Data

Launch Excel and create a spreadsheet with two date columns: start date and end date. Enter your dates in standard format (MM/DD/YYYY) in separate cells, for example A2 and B2.

Click on the Target Cell

Select the cell where you want the result to appear (e.g., cell C2). This is where the calculated day difference will be displayed.

Enter the DAYS360 Formula

Type the formula =DAYS360(start_date, end_date) into the cell. For example: =DAYS360(A2,B2) to calculate days between dates in cells A2 and B2.

Optional: Add Method Parameter

To use the European 30/360 method instead of the US method, add FALSE as third parameter: =DAYS360(A2,B2,FALSE). TRUE or omission uses US NASD method (default).

Press Enter and Copy Formula

Press Enter to confirm the formula and see the result. Select the cell and drag the fill handle down to apply the formula to additional rows.

Alternative Methods

Use DAYS Function for Actual Days

For actual calendar days (365/366-day year), use =DAYS(end_date, start_date) instead. This provides exact day counts rather than the 360-day basis.

Use Date Subtraction Formula

Simply subtract dates using =end_date-start_date for a quick daily difference. However, this doesn't follow financial conventions and may produce different results.

Tips & Tricks

✓Always ensure dates are recognized as date values, not text; format cells as Date if needed (Home > Format Cells > Number tab > Date category)
✓DAYS360 is ideal for financial instruments and bond calculations following the 30/360 day-count convention
✓The function always returns an integer; no decimal places are shown

Pro Tips

★Combine DAYS360 with interest rate calculations: multiply result by daily rate to compute accrued interest on bonds
★Use conditional formatting to highlight when DAYS360 calculations exceed specific thresholds for deadline tracking
★Nest DAYS360 within IF statements to automate financial period analysis based on day-count results

Troubleshooting

#VALUE! error appears in the cell

Check that both dates are properly formatted as date values, not text. Right-click cells > Format Cells > Number tab > select Date category and appropriate format.

Results are negative or unexpected

Verify the date order: DAYS360 calculates (end_date - start_date). Swap the cell references if the first date should be later than the second.

Function returns different results than expected

Confirm which method you need: add TRUE or omit third parameter for US NASD (default), or add FALSE for European 30/360 method.

Related Excel Formulas

DAYS DATE DATEDIF NETWORKDAYS YEAR MONTH DAY

Frequently Asked Questions

What is the difference between DAYS360 and DAYS functions?

DAYS360 calculates days using a 360-day year (30 days per month), following financial conventions, while DAYS counts actual calendar days (365 or 366). DAYS360 is standard for bond and interest calculations, whereas DAYS provides real elapsed time.

Why would I use a 360-day year instead of 365 days?

The 360-day convention (30/360 method) is standard in financial markets for bond pricing, yield calculations, and interest accrual. It simplifies calculations and ensures consistency across global financial institutions.

Can DAYS360 handle dates from different years?

Yes, DAYS360 correctly handles dates spanning multiple years. The function automatically calculates the total day difference regardless of whether dates cross year boundaries.

What does the TRUE/FALSE parameter in DAYS360 do?

The third parameter selects the day-count method: TRUE or omitted uses the US NASD method (default), while FALSE uses the European 30/360 method. Both treat months as 30 days but differ in how they handle month-end dates.