Formulas and Functions
ଏହି କଣ୍ଟ‍୍ରୋଲ୍‌କୁ ପରିବର୍ତ୍ତନ କରିବା ଫଳରେ ଏହି ପୃଷ୍ଠା ସ୍ବୟଂଚାଳିତ ଭାବରେ ଅପ୍‌ଡେଟ୍ ହୋଇଯିବ

DAYS360

The DAYS360 function returns the number of days between two dates based on twelve 30-day months and a 360-day year.

DAYS360(start-date, end-date, use-euro-method)

start-date: The starting date. start-date is a date/time value (the time portion is ignored) or date string.

end-date: The ending date. end-date is a date/time value (the time portion is ignored) or date string.

use-euro-method: An optional modal value that specifies the method to use for dates falling on the 31st of a month.

NASD method (0, FALSE or omitted): Use the NASD method for dates falling on the 31st of a month.

EURO method (1 or TRUE): Use the European method for dates falling on the 31st of a month.

Examples

=DAYS360("20/12/2008","31/3/2009") returns 101d.

=DAYS360("27/7/2008","31/3/2009",0) returns 394d.

=DAYS360("27/2/2008","31/3/2009",1) returns 393d, because the European calculation method is used.

See alsoDATEDIFNETWORKDAYSYEARFRAC
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ସହାୟକ କି?
କ‍୍ୟାରେକ୍ଟର୍ ସୀମା: 250
ସର୍ବାଧିକ କ‍୍ୟାରେକ୍ଟର୍ ସୀମା 250 ଅଟେ।
ଆପଣଙ୍କ ମତାମତ ପାଇଁ ଧନ‍୍ୟବାଦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.