Excel DAYS360 Function is a useful tool that helps you calculate the number of days between two dates using a 360-day year, often used in financial and accounting contexts. This function can be especially handy for calculating interest or time periods in financial calculations.

## Syntax

**DAYS360(start_date, end_date, [method])**

## Arguments

start_date | The initial date from which you want to calculate the days. |

end_date | The final date up to which you want to calculate the days. |

[method] | (Optional) An optional argument that specifies the method to use for day count calculation. If omitted, it defaults to the U.S. (NASD) method. |

**start_date:** The initial date from which you want to calculate the days.

**end_date:** The final date up to which you want to calculate the days.

**[method] (Optional):** An optional argument that specifies the method to use for day count calculation. If omitted, it defaults to the U.S. (NASD) method.

## How to use

To use the DAYS360 function, follow these steps:

- Enter the formula in a cell where you want the result to appear.
- Provide the start_date and end_date arguments as cell references or valid date values.
- If needed, add the optional method argument to specify the calculation method.
- Press Enter to get the calculated result.

Here are some examples of how to use the DAYS360 function:

Assuming cell A1 contains the start_date and cell B1 contains the end_date, use this formula to calculate the number of days between these two dates:

1 |
=DAYS360(A1, B1) |

If you want to use a different day count method, such as the European method, you can include the optional method argument like this:

1 |
=DAYS360(A1, B1, 2) |

The method argument can be:

**0 (or omitted):** U.S. (NASD) method

**1:** Actual/360 method

**2:** Actual/365 method

**3:** European method

Additional Information:

It’s important to note that the DAYS360 function calculates days based on a 360-day year, which can be different from the actual number of days between two dates. Be aware of this when using the function in financial calculations.