Logo
×

Excel Function and Formulas

Excel Today() Function

The today() function returns the serial number of today’s date as per system number of today’s date as per system’s regional settings.

Syntax

Today()

Parameter

NA

Category

Date & Time

Returns

This function returns today's date in date format.

Example 1

Objective: To get the current date

Result Formula
11/6/2019   =Today()

Example 2

Objective: Add 5 days to the current date and return the future date in a cell

Result Formula
11/11/2019   =Today()+5

Example 3

Objective: Calculate number of days between today's date and date in Col A

Result Formula Result
12/31/2015   =Today()-12/31/2015   1406
1/3/2010   =Today()- 1/3/2010   3594  
12/11/2015   =Today() - 12/11/2015   1426

Excel Now() Function

The now() function in Excel Returns the serial number of current date and time as per the system's regional settings.

Syntax

Now()

Category

Date & Time

Parameter

NA

Return

This function returns current date and time in excel date and time format

Example 1

Objective: Get the current date and time stamp in cell

Result Formula
11/6/2019 21:52   =Now ()

Example 2

Objective: To return the current time only in cell

Result Formula
21:52   =Now ()- Today()

Example 3

Objective: To calculate the Date and Time 7 days ago

Result Formula
10/30/2019 22:02   =Now ()- 7

Excel Upper Function

The Upper() function in excel  converts the text to uppercase.

Syntax

Upper(text)

Parameter

text(required)- This parameter represents the string for which you want to convert all letters into UPCASE

Category

Text

Return

This function returns the entire text string after converted into uppercase letters

Example 1

Objective: Change the ‘Name’ column in Uppercase

Name Formula Result
Varun SYEda   =Upper(Varun SYEda)   VARUN SYEDA
RAYAEL Pereyra   =Upper(RAYAEL Pereyra)   RAYAEL PEREYA
ThOMAs AlWachELL   =Upper(ThOMAs AlWachELL)   THOMAS ALWACHELL
ASHISH KUMAR PaTRA   =Upper(ASHISH KUMAR PaTRA)   ASHISH KUMAR PATRA
DELIA AZAHARI   =Upper(DELIA AZAHARI)   DELIA AZAHARI
mAR martin cASTellano   =Upper(mAR martin cASTellano)   MAR MARTIN CASTELLANO
DanIEL OSO   =Upper(DanIEL OSO)   DANIEL OSO
AmAN BHArDWAJ   =Upper(AmAN BHArDWAJ)   AMAN BHARDWAJ
KRiya BhansALI   =Upper(KRiya BhansALI)   KRIYA BHANSALI

Example 2

Objective: To convert the values in Text column into UPPERCASE
Text Result Formula
Laptop LAPTOP  =UPPER(A15)
Excel EXCEL  =UPPER(A16)
superstore is closed now SUPERSTORE IS CLOSED NOW  =UPPER(A17)

Excel Lower Function

The Lower() function in excel  converts the text to lowercase.

Syntax

Lower (text)

Parameter

text(required)- This parameter represents the string for which you want to convert all letters into LOWERCASE

Category

Text

Return

This function returns the entire text string after converted into lowercase letters

Example 1

Objective: Change the ‘Name’ column in Lowercase

Name Formula Result
Varun SYEda   =Lower(Varun SYEda)   varun syeda
RAYAEL Pereyra   = Lower (RAYAEL Pereyra)   rayael Pereyra
ThOMAs AlWachELL   = Lower (ThOMAs AlWachELL)   thomas alwachell
ASHISH KUMAR PaTRA   = Lower (ASHISH KUMAR PaTRA)   ashish kumar patra
DELIA AZAHARI   = Lower (DELIA AZAHARI)   delia azahari
mAR martin cASTellano   = Lower (mAR martin cASTellano)   mar martin castellano
DanIEL OSO   = Lower (DanIEL OSO)   daniel oso
AmAN BHArDWAJ   = Lower (AmAN BHArDWAJ)   aman bhardwaj
KRiya BhansALI   = Lower (KRiya BhansALI)   kriya bhansali

Example 2

Objective: To convert the values in Text column into LOWERCASE
Text Result Formula
Laptop laptop  =LOWER (A15)
Excel excel  =LOWER(A16)
superstore is closed now superstore is closed now  =LOWER(A17)

Excel Proper Function

The Proper () function in excel capitalizes the first letter in each word of a text value.

Syntax

Proper (text)

Parameter

text(required)- This parameter represents the string for which you want to convert all letters into PROPERCASE

Category

Text

Return

This function returns the entire text string after converted into propercase letters

Example 1

Objective: Change the ‘Name’ column in Propercase

Name Formula Result
Varun SYEda   =Proper(Varun SYEda)   Varun Syeda
RAYAEL Pereyra   = Proper(RAYAEL Pereyra)   Rayael Pereyra
ThOMAs AlWachELL   = Proper(ThOMAs AlWachELL)   Thomas Alwachell
ASHISH KUMAR PaTRA   = Proper(ASHISH KUMAR PaTRA)   Ashish Kumar Patra
DELIA AZAHARI   = Proper(DELIA AZAHARI)   Delia Azahari
mAR martin cASTellano   = Proper(mAR martin cASTellano)   Mar Martin Castellano
DanIEL OSO   = Proper(DanIEL OSO)   Daniel Oso
AmAN BHArDWAJ   = Proper(AmAN BHArDWAJ)   Aman Bhardwaj
KRiya BhansALI   = Proper(KRiya BhansALI)   Kriya Bhansali

Example 2

Objective: To convert the values in Text column into UPPERCASE
Text Result Formula
Laptop Laptop  = Proper (A15)
Excel Excel  = Proper (A16)
superstore is closed now Superstore Is Closed Now  = Proper (A17)

Related Topics

Text to columns in Excel

Microsoft Excel is widely used in startups to large companies. The data are entered in required rows and columns, and sometimes the data entered in one cell needs to enter...

4 minutes read.

Count Cells with Text in Excel

Excel spreadsheets are widely used in many fields to store and analyze data. Usually, the cells present in excel are a combination of numbers and text. To perform the calculation...

3 minutes read.

How to use TODAY function in Excel

What is TODAY Function in Excel? Today function is one of the types of Worksheet function (WS) in Excel.Today Function belongs to the Date and Time functions.It is used to calculate...

3 minutes read.

Copying formula in Excel

Copy a formula in Excel While working with statistical calculations in Microsoft Excel, the user uses formulas to calculate the mathematical operations. Implementing these formulas manually for each data is a...

3 minutes read.

Formatting in Excel

Formatting in Excel Formatting in Excel is used to alter and change the appearance of your data in a standardized form. It also helps you to give a professional look to your reports, worksheets,...

7 minutes read.

Thermometer Chart in the Microsoft Excel

It was known that the thermometer chart is basically based on a single data point and that in turn could be used to show the achievement percentage. It primarily depends...

7 minutes read.

Formats in Excel

What are the formats? Formats are different options that one uses to change the appearance of data (maybe text, number, etc..) in an excel file. They do not change the value of the...

3 minutes read.

Conditional Formatting in Excel

Conditional Formatting What are the conditional formats? Conditional Formatting is a tool that allows the user to format cells or range of cells based on the selected condition or given criteria. The formatting will...

4 minutes read.

Excel WORKDAY.INTL() Function

Excel WORKDAY.INTL() Function The WORKDAY.INTL() function in excel returns a date before or after a specified number of workdays with custom weekend parameter. Syntax WORKDAY.INTL (START_DAY, DAYS,[WEEKEND],[HOLIDAYS]) Parameter START_DAY (required)- This parameter represents the initial date...

2 minutes read.

Purpose of Randomize in Excel

Excel spreadsheets are used on a large scale for business and personal usage. It is used to store data, perform multiple calculations, make assumptions based on charts and graphs etc....

7 minutes read.

Excel SECOND() Function

Excel SECOND() Function The SECOND() function in excel converts a serial number to SECOND (0 - 59). Syntax SECOND (SERIAL_NUMBER) Parameter SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract...

1 minute read.

Excel IF() Function

Excel IF() Function: The IF() function in excel checks whether a condition is true or not and returns one value if the condition is TRUE and another value if it's...

2 minutes read.

Excel Themes

Microsoft Excel contains various features to enhance the appearance of the worksheet like text color, font size and general outlook of the objects. The users are provided with multiple theme...

3 minutes read.

How to make use of the Wildcard in Excel

In this modern world, it is known that the wildcard characters in Microsoft Excel are considered to be the most essential and unrated features of Microsoft Excel. Besides all these,...

8 minutes read.

Count Characters in Excel

Microsoft Excel is used to perform calculations for multiple purposes. The data entered in the worksheet is a combination of numeric and alphabets. Sometimes there is a need to check...

4 minutes read.

Excel VLOOKUP() Function

Excel VLOOKUP() Function The VLOOKUP() function in excel is used to lookup the value on the leftmost side of the table and then return the value in the corresponding row basis on the supplied...

2 minutes read.

Frequency Distribution in Excel

The term Frequency Distribution in Microsoft Excel is mainly used to explain how the data will be spread out. And it could be achieved with the help of the Histogram,...

7 minutes read.

Trendline in Excel

A Trendline is a line imposed on a graph to predict the direction of the data. It connects the series of data together to showcase the data best fit. The...

3 minutes read.

What do you understand by Combination Chart in Microsoft Excel?

In Microsoft Excel, an individual has the Combo Chart option available, which can be effectively clubbed into two charts types, which are Column Clusters Chart, Line Chart to get the...

7 minutes read.

Excel COUNTA() Function

Excel COUNTA() Function The COUNTA() function counts the number of cells in a range that are not empty. Syntax COUNTA([value1], [value [2], ...) Parameter value1(required)- This parameter represents the first cell in the range. value2, …(optional)- It represents...

1 minute read.