Search Not Just Numbers

Tuesday, 1 October 2013

Excel Tip: The power of NOW - Using the current time and date in Excel

Just a short post today because I have a very tight deadline to meet on a publication I am writing for the ICAEW (The Institute of Chartered Accountants here in England) on Automating Management Accounts in Excel.

Before we get into the post though, I have some exciting news for those of you who missed out on Mynda Treacy's Excel Dashboards course last time around. The course will be made available again for a limited time later this month. In the meantime, you can (re)read Mynda's guest post on the subject of Excel Dashboards here.

If you want to make sure you don't miss out this time, ensure that you are subscribed to the blog as I will keep subscribers updated. If you are not a subscriber, you can do so by leaving your email address in the form at the top right of the blog.

Today's post is a quick tip on how to use the current time and date in Excel.

There are two very similar functions that Excel provides for this - NOW and TODAY.

Both functions have no arguments but must still be followed by the (empty) brackets.

=NOW() returns the current date and time

=TODAY() returns the current date (actually it returns midnight at today's date)

I covered how Excel handles dates and time in a post a couple of weeks ago. Looking at the functions in those terms - NOW returns the full serial number for the current date and time and TODAY returns that serial number rounded down to the nearest whole number,

This functions can be used on their own, or as values in formulae, e.g using =TODAY()-A1 to calculate the elapsed time since the date in A1.

One caution to add to using these functions is that the values only update when Excel recalculates. Assuming you have the default calculation settings in Excel, recalculation will occur when any value changes in the spreadsheet, and when the spreadsheet is opened.

In most practical applications this is not a problem for the TODAY function unless the spreadsheet is open and unedited overnight. Obviously, it can be more of an issue with the NOW function.

You can, however, use the F9 key to force a recalculation at any point.

Right, back to Automating Management Accounts!

Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get your free report "The 5 Excel features that you NEED to know".


  1. If you prefer a preppy appearance, put them on by using a tiny jumper, aimple replacement affordable handbags together with an article of geek posh rimmed glasses or contact lenses. Just the thing you really need to be wary of happen to be hermes outlet the fact that carry out higher than any hip, mainly because those provide everyone some sort of hard lookinghape. Bomber replacement affordable handbags would definitely be a notably lousy offender during this view. When it is frigid out of doors, you could logpile plenty of cellular layers onto your higher fifty percent of mainly because you might want to not having discrediting ontyle askinny fake handbags normally stabilize any unwanted weight released beautifully. At the time you were definitely microscopic, cold months was initially the perfect opportunity meant for bundling away during cellular layers together with cellular layers for puffy anoraks together with significant leather gloves together with mittens to ensure you may well execute during the glaciers unscathed, however , the fact that appearance should be attractive over the in tens. This current year, in place of flipping all by yourself suitable fake watches for jumpers together with unflattering warm layers, look at most of the cool possibilities designed to always keep frostbite at bay despite the fact that exiting everyone browsing terrific. One of the greatest tips on how to vacation heat could be to decide fake rolex dateJust that have already numerous cellular layers. Warm air is caught up somewhere between cellular layers for dresses, which means that that you're more effective out being dressed in a couple of somewhat tiny cellular layers compared with that you're concealing all by yourself of hospitality attire substantial jumper. This means you will not the right gifts major, heaviest overcoat these days, everyone only have to believe that shrewd as to what to your dress in underneath it on the other hand. One other factor that could be regularly not considered stands out as the empathy within the fake prada bags. Given that it can be a all natural dietary fibre, it is actually very soft over the complexion and definitely will reduce the annoyance some people will own private complexion.

  2. Do you wonder whether or not designer clothing is worth the cost. Do you think that some cartier watches sale are out of their minds for spending so much on a simple part of clothing. If so, continue reading and you'll find out why individuals who refuse to buy designer clothing could actually end up spending more on their wardrobes than those who wear replica chanel handbags couture designs. Here is a list of benefits associated with designer clothing. Hopefully this will clean up any chanel replica you may have had about spending a little extra cash on high end designs. As you probably know by louis vuitton replica bags, designer clothing is made with the best quality of materials, completely of that time period. Guess what happens you're getting and they aren't trying to trick you. They are hinting very clearly and this piece was designed by the best designers in the industry and rolex replica uk the highest quality materials possible and but you'll have to pay the price, otherwise we're not making any profit.