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.
“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.
“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()
There are no arguments for “TODAY” function. Just apply the function and click “Enter”. It will show the current Date.
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”
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.
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
Then -> Go to Menu Bar- > Click to Home-> Click Paste Values
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.
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
Excel Function REPLACE REPLACE function is used to replace the existing text from a specific location in a cell to New Text. REPLACE Function has argument four arguments i.e. old_text, start_num, num_chars and new_text. We need to give the…
Excel Function- WORKDAY.INTL WORKDAY.INTL function is an advanced version of WORKDAY function with additional advantage of “Custom weekend options” For Example, with WORKDAY function weekends are treated as “Saturday and Sundays” however if you need…
ROW function is used to get the row reference number of the excel worksheet. ROW Function has only one argument i.e. reference,
COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.
AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.