Pinterest Pixel

DAYS360 Formula in Excel

  What does it do? Gets the number of days between two dates using 30-day months Formula... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

DAYS360 Formula in Excel | MyExcelOnline DAYS360 Formula in Excel | MyExcelOnline

 

What does it do?

Gets the number of days between two dates using 30-day months

Formula breakdown:

=DAYS360(start_date, end_date, [method])

What it means:

=DAYS360(starting date, ending date, [US or European Method])


If you need to get the difference of two dates, but want to use 30-day months in calculating the difference, Excel has you covered! We can use the DAYS360 Formula to do this. It can be useful in the accounting world and there are two modes that are used to count the number of days:

US Method (Default)

  • If your start date is the last day of the month, then it is treated as the 30th day of the same month
  • If your end date is the last day of the month and your start date is earlier than the 30th day of the month, then the end date is treated as the 1st day of the NEXT month, otherwise the end date is treated as the 30th day of the same month
See also  DATEVALUE Formula in Excel

European Method

  • If your start date or end date is the 31st day of the month, then it is treated as the 30th day of the same month

We will be using the Default US Method in our examples below!

I explain how you can do this below:

DAYS360 Formula in Excel | MyExcelOnline

Download excel workbookDAYS360-FORMULA.xlsx

STEP 1: We need to enter the DAYS360 function in a blank cell:

=DAYS360(

DAYS360 Formula in Excel

 

STEP 2: The DAYS360 arguments:

start_date

What is the start date?

Select the cell containing the starting date:

=DAYS360(C9,

DAYS360 Formula in Excel

end_date

What is the end date?

Select the cell containing the ending date:

=DAYS360(C9, D9)

DAYS360 Formula in Excel

 

We will leave the method as blank and use the default US method. Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

DAYS360 Formula in Excel

You now have your differences using 30-day months! Notice that 1 year is treated as 360 days (30 days x 12 months).

See also  ADDRESS Formula in Excel

DAYS360 Formula in Excel

 

How to Use the DAYS360 Formula in Excel

 

 

DAYS360 Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share it
DAYS360 Formula in Excel | MyExcelOnline DAYS360 Formula in Excel | MyExcelOnline
DAYS360 Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...