Today Function

EXCEL FUNCTION – TODAY

EXCEL FUNCTION – TODAY

Today Function

How to use “TODAY” function in Excel

Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.

Function should give output in Date format, however if output is not as per the desired date format, then we need to change the cell format to “DATE”. We will be discussing the steps that how we can change the cell format to Date in detail.

Date derived from TODAY function changes each time worksheet is refreshed/ edited/open/changed. So, ensure to Paste special values the formula output so that database is not changed. We will also discuss in below that how we can Paste special values.

 

Advantage of “TODAY Function”

“TODAY” function is very advantageous in many ways. It helps for the document where current Date details are required in more often. Applying current Date manually (one by one) to document is very difficult and “TODAY Function” helps to apply the function in large database at once and makes the work easy, saves time and increases efficiency.

 

Where “TODAY” function can be used:

“TODAY Function” is very useful and can be used in many situations. Like it can be used as follows:

– Document where Date stamps are required more often.

– Preparing time and motion study and day wise summary for employees

– Employees utilization or productivity, attendance tracker

– Or any other database where there is requirement of current Date stamps, “TODAY Function” can be used

 

“TODAY” Syntax:
=TODAY()
Syntax Description:

There are no arguments for “TODAY” function. Just apply the function and click “Enter”. It will show the current Date.

Example 1: Apply “TODAY Function”, also change the Date format to DATE Format
Today Function

If output of the function is not as per the above (i.e. DATE), then we need to change the cell format. Follow below steps to change the format of the cell:

Step 1: Select the Cell or Data Range

Step 2: Press Ctrl + 1 to open “Format Cells” option

Step 3: Select the option as per below i.e. Date -> 14-Mar-12

Step 4: Click to “OK”

Today function

This will change the format of the cell to desired format. We can change ANY of the Date or Time format as given in “Format Cell” option.

—————-

Things to Remember:

Values derived from TODAY function changes each time worksheet is refreshed/ edited/open/changed. So, ensure to Paste special values the formula output so that database is not changed.

Below are the steps for paste special database to values:

– Select the data range -> Go to Menu Bar- > Click to Home-> Click to Copy

Now function

Then -> Go to Menu Bar- > Click to Home-> Click Paste Values

Now Function

Hope you learnt this Function

Don’t forget to leave your valuable comments!

If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons.

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you a Data Enthusiast?

Join us for a ride on your data and automate your stuffs

Business Analytics
Data Analyst
Programming for Data Science
Predictive Analytics for Business