EXCEL DATE AND STATISTICS FUNCTIONS

DATE =     Returns the serial number of a particular date

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

DAY =     Converts a serial number to a day of the month

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

EDATE =     Returns the serial number of the date that is the indicated number

of months before or after the start date

EOMONTH =     Returns the serial number of the last day of the month before or after

a specified number of months

HOUR =     Converts a serial number to an hour

MINUTE =     Converts a serial number to a minute

MONTH =     Converts a serial number to a month

NETWORKDAYS =     Returns the number of whole workdays between two dates

NOW =     Returns the serial number of the current date and time

SECOND =     Converts a serial number to a second

TIME =     Returns the serial number of a particular time

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

TODAY =     Returns the serial number of today's date

WEEKDAY =     Converts a serial number to a day of the week

WEEKNUM =     Converts a serial number to a number representing where the week

falls numerically with a year

WORKDAY =     Returns the serial number of the date before or after a

specified number of workdays

YEAR =     Converts a serial number to a year

YEARFRAC =     Returns the year fraction representing the number of whole days

between start_date and end_date

AVEDEV =     Returns the average of the absolute deviations of data points from their mean

AVERAGE =     Returns the average of its arguments

AVERAGEA =     Returns the average of its arguments, including numbers, text

and logical values

BETADIST =     Returns the beta cumulative distribution function

BETAINV =     Returns the inverse of the cumulative distribution function for

a specified beta distribution

BINOMDIST =     Returns the individual term binomial distribution probability

CHIDIST =     Returns the one-tailed probability of the chi-squared distribution

CHIINV =     Returns the inverse of the one-tailed probability of the chi-squared distribution

CHITEST =     Returns the test for independence

CONFIDENCE =     Returns the confidence interval for a population mean

CORREL =     Returns the correlation coefficient between two data sets

COUNT =     Counts how many numbers are in the list of arguments

COUNTA =     Counts how many values are in the list of arguments

COUNTBLANK =     Counts the number of blank cells within a range

COUNTIF =     Counts the number of nonblank cells within a range that meet the given criteria

COVAR =     Returns covariance, the average of the products of paired deviations

CRITBINOM =     Returns the smallest value for which the cumulative binomial

distribution is less than or equal to a criterion value

DEVSQ =     Returns the sum of squares of deviations

EXPONDIST =     Returns the exponential distribution

FDIST =     Returns the F probability distribution

FINV =     Returns the inverse of the F probability distribution

FISHER =     Returns the Fisher transformation

FISHERINV =     Returns the inverse of the Fisher transformation

FORECAST =     Returns a value along a linear trend

FREQUENCY =     Returns a frequency distribution as a vertical array

FTEST =     Returns the result of an F-test

GAMMADIST =     Returns the gamma distribution

GAMMAINV =     Returns the inverse of the gamma cumulative distribution

GAMMALN =     Returns the natural logarithm of the gamma function, Γ(x)

GEOMEAN =     Returns the geometric mean

GROWTH =     Returns values along an exponential trend

HARMEAN =     Returns the harmonic mean

HYPGEOMDIST =     Returns the hypergeometric distribution

INTERCEPT =     Returns the intercept of the linear regression line

KURT =     Returns the kurtosis of a data set

LARGE =     Returns the k-th largest value in a data set

LINEST =     Returns the parameters of a linear trend

LOGEST =     Returns the parameters of an exponential trend

LOGINV =     Returns the inverse of the lognormal distribution

LOGNORMDIST =     Returns the cumulative lognormal distribution

MAX =     Returns the maximum value in a list of arguments

MAXA =     Returns the maximum value in a list of arguments, including numbers,

text, and logical values

MEDIAN =     Returns the median of the given numbers

MIN =     Returns the minimum value in a list of arguments

MINA =     Returns the smallest value in a list of arguments, including numbers,

text, and logical values

MODE =     Returns the most common value in a data set

NEGBINOMDIST =     Returns the negative binomial distribution

NORMDIST =     Returns the normal cumulative distribution

NORMINV =     Returns the inverse of the normal cumulative distribution

NORMSDIST =     Returns the standard normal cumulative distribution

NORMSINV =     Returns the inverse of the standard normal cumulative distribution

PEARSON =     Returns the Pearson product moment correlation coefficient

PERCENTILE =     Returns the k-th percentile of values in a range

PERCENTRANK =     Returns the percentage rank of a value in a data set

PERMUT =     Returns the number of permutations for a given number of objects

POISSON =     Returns the Poisson distribution

PROB =     Returns the probability that values in a range are between two limits

QUARTILE =     Returns the quartile of a data set

RANK =     Returns the rank of a number in a list of numbers

RSQ =     Returns the square of the Pearson product moment correlation coefficient

SKEW =     Returns the skewness of a distribution

SLOPE =     Returns the slope of the linear regression line

SMALL =     Returns the k-th smallest value in a data set

STANDARDIZE =     Returns a normalized value

STDEV =     Estimates standard deviation based on a sample

STDEVA =     Estimates standard deviation based on a sample, including numbers,

text, and logical values

STDEVP =     Calculates standard deviation based on the entire population

STDEVPA =     Calculates standard deviation based on the entire population,

including numbers, text, and logical values

STEYX =     Returns the standard error of the predicted y-value for each x in the regression

TDIST =     Returns the Student's t-distribution

TINV =     Returns the inverse of the Student's t-distribution

TREND =     Returns values along a linear trend

TRIMMEAN =     Returns the mean of the interior of a data set

TTEST =     Returns the probability associated with a Student's t-test

VAR =     Estimates variance based on a sample

VARA =     Estimates variance based on a sample, including numbers, text, and logical values

VARP =     Calculates variance based on the entire population

VARPA =     Calculates variance based on the entire population, including numbers,

text, and logical values

WEIBULL =     Returns the Weibull distribution

ZTEST =     Returns the one-tailed probability-value of a z-test