LibreOffice 25.2 žinynas
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(2 data; 1 data)
1 data – pradžios data, 2 data – pabaigos data. Jei 2 data yra ankstesnė už 1 data, tai rezultatas neigiamas skaičius.
=DAYS(TODAY();"2010-01-01")) returns the number of days from January 1, 2010 until today.
=DAYS("1990-10-10";"1980-10-10") grąžina 3652 dienas.
=DAYS(NOW(); TODAY()) returns a fraction of the current day.