Excel Formulas

Showing page 10 of 21
RRI
Financial

Returns an equivalent interest rate for the growth of an investment

SLN
Financial

Returns the straight-line depreciation of an asset for one period

SYD
Financial

Returns the sum-of-years' digits depreciation of an asset for a specified period

VDB
Financial

Returns the depreciation of an asset using a variable declining balance method

WEEKNUM
Date

Returns the week number of a specific date

WORKDAY
Date

Returns a date a specified number of workdays before or after a date

NETWORKDAYS
Date

Returns the number of whole working days between two dates

EDATE
Date

Returns a date a specified number of months before or after a start date

EOMONTH
Date

Returns the last day of the month before or after a specified number of months

DAYS360
Date

Calculates the number of days between two dates based on a 360-day year

DATEDIF
Date

Calculates the number of days, months, or years between two dates

WEEKDAY
Date

Returns the day of the week corresponding to a date

HOUR
Date

Converts a serial number to an hour

MINUTE
Date

Converts a serial number to a minute

SECOND
Date

Converts a serial number to a second

TIME
Date

Returns the serial number of a particular time

TIMEVALUE
Date

Converts a time in the form of text to a serial number

NOW
Date

Returns the serial number of the current date and time

TODAY
Date

Returns the serial number of today's date

DATEVALUE
Date

Converts a date in the form of text to a serial number

Page 10 of 21