**60 useful excel formulas that are a good to know**

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

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

MONTH = Converts a serial number to a month

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

TODAY = Returns the serial number of today’s date

YEAR = Converts a serial number to a year

CLEAN = Removes all nonprintable characters from text

FIND = Finds one text value within another (case-sensitive)

LEFT = Returns the leftmost characters from a text value

LEN = Returns the number of characters in a text string

LOWER = Converts text to lowercase

MID = Returns a specific number of characters from a text string starting at the position you specify

REPLACE = Replaces characters within text

REPT = Repeats text a given number of times

RIGHT = Returns the rightmost characters from a text value

SUBSTITUTE = Substitutes new text for old text in a text string

UPPER = Converts text to uppercase

AVERAGE = Returns the average of its arguments

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

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

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

MAX = Returns the maximum value in a list of arguments

MEDIAN = Returns the median of the given numbers

MIN = Returns the minimum value in a list of arguments

MODE = Returns the most common value in a data set

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

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

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

STDEV = Estimates standard deviation based on a sample

AND = Returns TRUE if all its arguments are TRUE

FALSE = Returns the logical value FALSE

IF = Specifies a logical test to perform

NOT = Reverses the logic of its argument

OR = Returns TRUE if any argument is TRUE

TRUE = Returns the logical value TRUE

LOG = Returns the logarithm of a number to a specified base

MOD = Returns the remainder from division

RANDBETWEEN = Returns a random number between the numbers you specify

ROUNDDOWN = Rounds a number down, toward zero

ROUNDUP = Rounds a number up, away from zero

SUM = Adds its arguments

SUMIF = Adds the cells specified by a given criteria

FV = Returns the future value of an investment

IRR = Returns the internal rate of return for a series of cash flows

NPV = Returns the net present value of an investment based on a series of periodic cash flows and a discount rate

PMT = Returns the periodic payment for an annuity

PV = Returns the present value of an investment

ADDRESS = Returns a reference as text to a single cell in a worksheet

HLOOKUP = Looks in the top row of an array and returns the value of the indicated cell

INDEX = Uses an index to choose a value from a reference or array

INDIRECT = Returns a reference indicated by a text value

LOOKUP = Looks up values in a vector or array

MATCH = Looks up values in a reference or array

OFFSET = Returns a reference offset from a given reference

ROW = Returns the row number of a reference

VLOOKUP = Looks in the first column of an array and moves across the row to return the value of a cell

GETPIVOTDATA = Returns data stored in a PivotTable

ISBLANK = Returns TRUE if the value is blank

ISERROR = Returns TRUE if the value is any error value

I have a question. Is there an excel formula that can calculate the 1st of the month following the previous 60 days. Our emplyees qualify for health benefits the first of the month following 60 days employment and i would like to put that in a spread sheet.

January 13th, 2016 at 5:01 pmCan you help me?