DAYS360

Returns the difference between two dates based on the 360 day year used in interest calculations.

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

DAYS360("Date1"; "Date2"; Type)

If Date2 is earlier than Date1, the function will return a negative number.

The optional argument Type determines the type of difference calculation. If Type = 0 or if the argument is missing, the US method (NASD, National Association of Securities Dealers) is used. If Type <> 0, the European method is used.

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

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