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.