Date & Time Function: DAYS360()

This formula returns the number of days between two specified dates assuming 360-day a year (twelve 30-day months).

DAYS360(start_date,end_date,method)

Method is a way to specify whether to use US or European system. When omitted, or FALSE, the formula will display in US system. TRUE will display European system.

For example: DAYS360("05/05/06","01/12/06")
Outcome = 206

This means there are 206 days between the above mentioned two dates. Please note the "Start Date" and "End Date" could be a cell reference with value of dates instead of putting in dates into the formula itself.

Keywords: Date, Time