Formulas and functions

Formulas and functions

Date and Time Functions

Calculate the current date with the TODAY function

Create a date with the DATE function

Format a date the way you want

Identify the day of the week with WEEKDAY

Count working days with NETWORKDAYS

Determine a completion date with WORKDAY 

Tabulate date/time differences with DATEDIF 

Insert the current date and time in a cell

Add or subtract dates

Add or subtract time

Calculate the difference between two dates

Calculate the difference between two times

Convert times

All date and time functions

Text functions

Create a text string and format it with the TEXT function

Extract the leftmost characters from a text value with LEFT, LEFTB 

Extract the rightmost characters from a text value with RIGHT, RIGHTB functions

Remove excess space with TRIM

Use CONCATENATE with functions

Combine the text from multiple ranges and/or strings with CONCAT (Excel 2016)

Locate a text string (case sensitive) within another string with FIND, FINDB functions

Locate a text string within another string with SEARCH, SEARCHB functions

Count characters in cells

Combine text and numbers

All text functions

Statistical functions 

Find the middle value with MEDIAN

Rank data without sorting with RANK

Return the largest value in a data set with LARGE

Return the smallest value in a data set with SMALL

Tabulat blank cells with COUNTBLANK 

Determine frequency distributions with FREQUENCY 

Build analysis via regression techniques with TREND

GROWTH function

All statistical functions

Math functions 

Round a number to the decimal places I want 

Find the remainder with MOD

Build random number generators with RAND

Generate random number between numbers you specify with RANDBETWEEN

Convert a value between measurement systems with CONVERT 

SUBTOTAL function

ROUND function

Round a number

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.