# 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