Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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

Tabulate 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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Find solutions to common problems or get help from a support agent.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!