Formula

Structure

Explanation

AVERAGE

=AVERAGE(A2:A10)

Returns a mathematical average of a given cell range

COUNT

=COUNT(A2:A10)

Returns the count of the numbers in given cell range

MAX

=MAX(A2:A10)

Finds the largest value in a given cell range

MEDIAN

=MEDIAN(A2:A10)

Returns the median value, or middle value, in a given cell range

MIN

=MIN(A2:A10)

Finds the smallest value in a given cell range

SUM

=SUM(A2:A10)

Totals numbers in a given cell range

Formula

Structure

Explanation

TODAY

=TODAY()

Volatile – takes no arguments – returns today’s date

NOW

=NOW()

Volatile – takes no arguments – returns today’s date and time

DATEDIF

=DATEDIF(Start Date, End Date, Unit)

Returns the number of years, months or days between two dates · Start Date – date furthest in the past · Unit could be “Y” for years, “M” for months or “D” for days · Units must be in double quotes · This formula is NOT in the function library

YEAR

=YEAR(Date)

· Returns the year portion of date · Example =YEAR(7/16/2005) would return 2005

MONTH

=MONTH(Date)

· Returns the month portion of date · Example =MONTH(7/16/2005) would return 7

DAY

=DAY(Date)

· Returns the day portion of date · Example =DAY(7/16/2005) would return 16