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)



ADVERTISEMENT
ADVERTISEMENT