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.