The Excel DAYS360 function returns the number of days between two dates based on a 360-day year. Calculations based on a 360-day year comes from certain accounting calculations where all 12 months are considered to have 30 days.
Get days between 2 dates in a 360-day year
A number representing days.
=DAYS360 (start_date, end_date, [method])
start_date - The start date.
end_date - The end date.
method - [optional] The type of day count basis to use. FALSE (default) is US method, TRUE is European method.
Notes on method:
FALSE - (default) - US method. when the start date is the last day of the month, it is set to the 30th day of the same month. When the end date is the last day of the month, and the start date < 30, the end date is set to the 1st of the next month, otherwise the end date is set to the 30th of the same month.
TRUE - European method. Starting dates and ending dates equal to the 31st of a month are set to the 30th of the same month.
The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.