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)
āϤāĻžāϰāĻŋāĻā§§ āĻļā§āϰā§āϰ āϤāĻžāϰāĻŋāĻ,āϤāĻžāϰāĻŋāĻ⧍ āĻļā§āώ āĻšāĻāϝāĻŧāĻžāϰ āϤāĻžāϰāĻŋāĻāĨ¤ āϝāĻĻāĻŋāϤāĻžāϰāĻŋāĻā§§āĻāϰ āĻĒā§āϰā§āĻŦā§ āϤāĻžāϰāĻŋāĻāĻāĻŋ āϤāĻžāϰāĻŋāĻ⧍ āĻšāϝāĻŧ āϤāĻžāĻšāϞ⧠āĻĢāϞāĻžāĻĢāϞ āĻāĻāĻāĻŋ āύā§āĻā§āĻāĻŋāĻ āϏāĻāĻā§āϝāĻžāĨ¤
=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.