Function will 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.
“NOW” function is very advantageous in many ways. It helps for the document where current Date and Time details are required in more often. Applying current Date and Time manually (one by one) to document is very difficult and “NOW function” helps to apply the function in large database at once and makes the work easy, saves time and increases efficiency.
“NOW function” is very useful and can be used in many situations. Like it can be used as follows:
– Document where Date/Time stamps are required more often.
– Preparing time and motion study for the employees to evaluate time consumed
– Employees utilization or productivity, attendance tracker
– Or any other database where there is requirement of current Date and Time stamps, “NOW function” can be used
=NOW()
There are no arguments for “NOW” function. Just apply the function and click “Enter”. It will show the current Date and Time.
If output of the function is not as per the above (i.e. DATE + TIME Format), 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 -> 3/14/2012 01:30 PM
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 NOW 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 liked. Happy Learning.
Don’t forget to leave your valuable comments!
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
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 COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
Calculations With Date In Excel Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are…
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k