Difference between =now() and =today() in Excel

Have you been wondering what the difference is between the Excel functions =today() and =now()? The two functions display the current date but the only difference is that the =now() function also displays the current time.

The two functions allow the date to be updated any time you reopen the your worksheet. If you do not want the date to be updated automatically, use the keyboard shortcut below in a cell where you want the date to be displayed.
CTRL+;
That is, use the CTRL and semicolon keys in a cell.

Comments

Post a Comment

Popular posts from this blog

Internet Explorer Has Stopped Working error

I got this message from my Internet Explorer today "Internet Explorer Has Stopped Working", and I had to fix the problem with the following procedure. I believe it will work for you too. 1. Close any instance of Internet Explorer 2. Click on Start button 3. Click Control Panel 4. Click Internet Options 5. Click the Advanced tab 6. Click on Reset button 7. Click on the Reset button again 8. Click Close 9. Now you can launch Internet Explorer Hope this helps... You may leave a message here.
Read more

ONLINE CURRENCY CONVERTER

Image
You do not need to have any knowledge of the current exchange rate to convert from the currency of one country to another. The online converter works magic and fast. You can convert from one currency to another with ease if you have internet connectivity. It is straight forward: 1. Go to http://www.google.com 2. Search for "currency converter" 3. The first item in your search result is the converter application showing the default interface which is that of your country and US. You can change this by simply selecting the country names of your choice from the selection buttons 4. Enter the currency value you want to convert and the converted value automatically displays on the other field. Take a look at the screenshot below. What is more? The data is reliable because it is always up-to-date. Have you being using any better tool? Tell us in the comment.
Read more