ExcelFormulasCheatSheet -1

 Excel Formulas Cheat Sheet

Basic Formulas

Formula	Structure	Explanation
AVERAGE	=AVERAGE(A2:A10)	Returnsamathematicalaverageofagivencellrange
COUNT	=COUNT(A2:A10)	Returnsthecountofthenumbersingivencell range
MAX	=MAX(A2:A10)	Findsthelargestvalueinagivencellrange
MEDIAN	=MEDIAN(A2:A10)	Returnsthemedianvalue,ormiddlevalue,inagivencellrange
MIN	=MIN(A2:A10)	Findsthesmallestvalueinagivencellrange
SUM	=SUM(A2:A10)	Totalsnumbersinagivencellrange

TimeFormulas

Formula	Structure	Explanation
TODAY	=TODAY()	Volatile–takesnoarguments–returnstoday’sdate
NOW	=NOW()	Volatile–takesnoarguments–returnstoday’sdateandtime
DATEDIF	=DATEDIF(StartDate,EndDate, Unit)	Returnsthenumberofyears,monthsordaysbetweentwodates ·         StartDate–datefurthestinthepast ·         Unitcouldbe“Y”foryears,“M”formonthsor“D”fordays ·         Unitsmust beindoublequotes ·         ThisformulaisNOTinthefunctionlibrary
YEAR	=YEAR(Date)	·         Returnstheyear portionof date ·         Example=YEAR(7/16/2005)wouldreturn2005
MONTH	=MONTH(Date)	·         Returnsthemonthportionofdate ·         Example=MONTH(7/16/2005)wouldreturn7
DAY	=DAY(Date)	·         Returnsthedayportion ofdate ·         Example=DAY(7/16/2005)wouldreturn16

Useatimeformulaandgetanansweryoudidn’texpect?Ifyougotadateandwereexpectinganumber,remembertochangetheformatting fromdatetonumber.Ifyougotanumberandwereexpectingadate,changetheformattingtodate.