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

Paste Options in Excel

Excel spreadsheet is a combination of numeric values, alphabets which is used for calculation purposes. While performing the calculations, there is a need to repeat the data for further process....

6 minutes read.

Averageif Function in Excel

Average If in HTML In Mathematics, Average function is used to find the arithmetic mean of the given data. It is defined as the dividing the sum total of given data...

7 minutes read.

Excel IFNA Function

Excel IFNA Function The IFNA in Excel is used to remove the #N/A type of errors in excel values cells with our choice of value. IFNA function is from Excel 2013 onwards, so it...

1 minute read.

Histogram in Excel

What is Histogram in Excel? “ A histogram is a graphical tool familiar for summarizing discrete or continuous data, where the data are measured on an interval scale.”  Karl Pearson described this...

5 minutes read.

Excel MID() Function

The MID() function in excel is used to return a specific number of characters from a text string starting at the position you specify. One can change the start of the string, thus...

1 minute read.

Array Formula in Excel

How to use Array Formula in Excel? By default, Excel consists of various formulas for calculating the data. Among various formulas, the Array formula is a powerful one that is used...

8 minutes read.

Excel MAX() Function

Excel MAX() Function The MAX() function in excel returns the largest or maximum number from a range of cells. It ignores logical values and text. Syntax MAX(Number1,Number2, ...) Parameter Number1(required)- This parameter represents the string for which you...

1 minute read.

Excel INDEX () Function

Excel INDEX () Function The INDEX() function in excel returns a value from a list of tables based on the intersection of a row and a column position. This function is used with the...

2 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.

Excel TIME() Function

Excel TIME() Function The TIME() function in excel returns the serial number of a particular time. Syntax TIME(HOUR, MINUTE, SECOND) Parameter HOUR (required)- This parameter represents the hour for your time. MINUTE (required)- This parameter represents the...

1 minute read.

Insert Row in Excel

It was known that we have various multiple ways that are extremely helpful in inserting a particular row in the Microsoft Excel. And we have lots of shortcut options available...

6 minutes read.

Excel ROUND() Function

Excel ROUND() Function The ROUND() function in excel rounds the numbers to specified digits. Syntax ROUND(Number,num_digits) Parameter Number(required)- This parameter represents the number which you want to round up. num_digits(required)- This parameter represents the number of decimal places to which...

1 minute read.

Excel EXACT() Function

The EXACT() function in excel checks whether the specified values (texts, numbers) are exactly the same or not. It returns a Boolean value TRUE if the compared values are same, else it...

1 minute read.

Excel EOMONTH() Function

Excel EOMONTH() Function The EOMONTH() function in excel returns the serial number of the last day of the month before or after a specified number of months. Syntax EOMONTH (Start_Date, Month) Parameter Start_Date(required)- This parameter...

1 minute read.

How to apply Advanced Filter in Excel

It was known that the advanced filter in Microsoft Excel is termed to be the next level filter option that is available in the particular "Data Menu Tab", which is...

7 minutes read.

Excel Axes

What is Excel Axes? Axes are a horizontal or vertical line containing units of measure. There are two types of axes X and Y axes. X is a horizontal and Y...

3 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 Alphabetize in Excel?

Alphabetize in Excel One of the reasons for Excel's widest popularity is its ability to swiftly and effortlessly sort data. Excel facilitates easy methods that alphabetically sort the lists of strings...

5 minutes read.

Excel AND() Function

The AND() function in excel tests the multiple sets of conditions and returns TRUE if all supplied conditions met the criterion, FALSE otherwise. You need to have a minimum of 2 conditions...

2 minutes read.

Data Analysis in Excel

Data Analysis in Excel Data analysis is a powerful tool that helps the users to make better decisions by comparing different information. Microsoft Excel extends its credibility to enforce the data analysis tool...

6 minutes read.