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.
Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments
WORKDAY Function in Excel Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most commonly used function in Excel…
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.
“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.