daysact

Actual number of days between dates

Syntax

NumDays = daysact(StartDate)

NumDays = daysact(___,EndDate)

Description

NumDays = daysact(StartDate) returns the actual number of days between the MATLAB^® base date and StartDate. In MATLAB, the base date 1 is 1-Jan-0000 A.D.

NumDays = daysact(___,EndDate) returns the actual number of days between StartDate and the optional argument EndDate.

If EndDate is earlier than StartDate, NumDays is negative. Under this convention, all months contain 30 days.

Either input argument can contain multiple values, but if so, the other must contain the same number of values or a single value that applies to all. For example, if StartDate is an n-row datetime, then EndDate must be an N-by-1 vector of integers or a single integer. NumDays is then an N-by-1 vector of date numbers.

Examples

Determine the Number of Days Between Two Dates Based the Actual Number of Days

Determine the NumDays using date character vectors for StartDate and EndDate.

NumDays = daysact('7-sep-2002',  '25-dec-2002')

NumDays = 
109

Determine the NumDays using datetimes for StartDate and EndDate.

NumDays = daysact(datetime(2002,9,7) , datetime(2002,12,25))

NumDays = 
109

Determine the NumDays using a datetime array for EndDate.

MoreDays = [datetime(2002,9,7) ; datetime(2002,10,22) ; datetime(2002,11,5)];
NumDays = daysact(MoreDays, '12/25/2002')

NumDays = 3×1

   109
    64
    50

Input Arguments

StartDate — Start date

datetime array | string array | date character vector

Start date, specified as a scalar or an N-by-1 or 1-by-N vector using a datetime array, string array, or date character vectors.

To support existing code, daysact also accepts serial date numbers as inputs, but they are not recommended.

Data Types: char | string | datetime

EndDate — End date

datetime array | string array | date character vector

End date, specified as a scalar or an N-by-1 or 1-by-N vector using a datetime array, string array, or date character vectors.

To support existing code, daysact also accepts serial date numbers as inputs, but they are not recommended.

Data Types: char | string | datetime

Output Arguments

NumDays — Number of days between two dates based actual number of days

vector

Number of days between two dates based on the actual number of days, returned as a scalar or an N-by-1 or 1-by-N vector containing the number of days.

References

[1] Addendum to Securities Industry Association, Standard Securities Calculation Methods: Fixed Income Securities Formulas for Analytic Measures. Vol. 2, Spring 1995.

Version History

Introduced before R2006a

R2022b: Serial date numbers not recommended

Although daysact supports serial date numbers, datetime values are recommended instead. The datetime data type provides flexible date and time formats, storage out to nanosecond precision, and properties to account for time zones and daylight saving time.

To convert serial date numbers or text to datetime values, use the datetime function. For example:

t = datetime(738427.656845093,"ConvertFrom","datenum");
y = year(t)

y =

        2021

There are no plans to remove support for serial date number inputs.