DAYS

Calculates the difference between two date values. The result returns the number of days between the two days.

αƒ‘αƒ˜αƒœαƒ’αƒαƒ₯αƒ‘αƒ˜

DAYS(αƒ—αƒαƒ αƒ˜αƒ¦αƒ˜_2;αƒ—αƒαƒ αƒ˜αƒ¦αƒ˜_1)

Date1 is the start date, Date2 is the end date. If Date2 is an earlier date than Date1 the result is a negative number.

αƒ›αƒαƒ’αƒαƒšαƒ˜αƒ—αƒ”αƒ‘αƒ˜

DAYS("1/1/2010"; NOW()) αƒαƒ‘αƒ αƒ£αƒœαƒ”αƒ‘αƒ‘ αƒ“αƒ¦αƒ”αƒ”αƒ‘αƒ˜αƒ‘ αƒ αƒαƒαƒ“αƒ”αƒœαƒαƒ‘αƒαƒ‘ αƒ“αƒ¦αƒ”αƒ˜αƒ“αƒαƒœ 2010 αƒ¬αƒšαƒ˜αƒ‘ 1 αƒ˜αƒαƒœαƒ•αƒ αƒαƒ›αƒ“αƒ”.

=DAYS("1990-10-10";"1980-10-10") returns 3652 days.