DAYS360 function

DAYS360 Function

Function Type:

Date and Time


Description:

DAYS360 function in Excel or Google Sheets is used to compute the number of days between 2 dates on a 360 days per year scale.
This accounts for 12 months with 30 days for each
12months x 30days = 360
This is equivalent to subtracting an End Date and a Start Date, but counting every month as 30 days.


Function Structure: 

=DAYS(start_date,end_date,[method])


Arguments 

start_date – this is the date or serial number representing a the start date

end_date – this is the date or serial number representing a the end date

[method] – logical value (boolean) accepting TRUE or FALSE. It can also be omitted to mean FALSE.
USA method – FALSE or [omitted]
Europe method – TRUE


Examples 

DAYS360 function examples

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour

We can also accept LEOHIVEHBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven šŸ˜‰


Back to Learn Excel->

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

One thought on “DAYS360 function

Leave a Reply

Discover more from Cash Heaven

Subscribe now to keep reading and get access to the full archive.

Continue reading