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.