DAYS360 Google Sheet Formula

Generate Google Sheet DAYS360 Formulas in seconds

Try Formula Generator View Examples

Interactive Formula Generator

Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Upgrade to Sheet Alchemy Pro

Get advanced formulas, batch processing, and priority support

Upgrade Now

Input

Result

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Pro Features Available

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Advanced Formulas

Complex array formulas and dynamic ranges

Batch Processing

Generate multiple formulas at once

Unlimited History

Save and organize all your formulas

DAYS360 Formula Syntax

=DAYS360("1/1/2023", "12/31/2023")

Example Use Case

Calculating days between dates based on a 360-day year

Understanding the DAYS360 Formula

The DAYS360 function in Excel calculates the days between two dates based on a 360-day year (twelve 30-day months), a banking and accounting convention. It's a specialized date difference tool for financial calculations—like interest accrual or bond yields where 30/360 day counting is standard.

DAYS360("1/1/2023", "12/31/2023") returns 359 or 360 depending on the method. It takes start_date, end_date, and optional method arguments (FALSE=US/NASD method, TRUE=European method), providing day counts that align with financial industry standards.

Why Use DAYS360?

DAYS360 standardizes financial periods—think bond calculations or international finance. Its 360-day year simplifies interest computations, matching industry conventions for more accurate financial modeling than calendar day counts.

Example with Sample Data

Date Range, Method	Formula	Result
1/1/2023 to 12/31/2023, US	=DAYS360("1/1/2023", "12/31/2023", FALSE)	359
1/1/2023 to 12/31/2023, Euro	=DAYS360("1/1/2023", "12/31/2023", TRUE)	360
1/15/2023 to 4/15/2023, US	=DAYS360("1/15/2023", "4/15/2023", FALSE)	90

DAYS360 uses financial conventions: 359 days US method, 360 European method for a full year. It's a financial day counter.