LibreOffice 25.2 Help
Calculates the difference between two date values. Returns the number of days between the two days. May return a fraction of a day when the arguments include time parts.
DAYS(Date2; Date1)
Date1 是指開始日期,Date2 為指結束日期。若 Date2 是早於 Date1 的日期,則結果會是負數。
=DAYS(TODAY();"2010-01-01")) returns the number of days from January 1, 2010 until today.
=DAYS("1990-10-10";"1980-10-10") returns 3652 days.
=DAYS(NOW(); TODAY()) returns a fraction of the current day.