«

»

NOW & TODAY

The functions TODAY and NOW are two extremely important functions. They allow you to create dynamic workbooks using the system date on your computer.

We will use these functions to create workbooks such as

  • Automatic calendar
  • Worker timesheet
  • Follow-up of supplier payments
  • Delivery delays
  • ...

Presentation of the functions


To view the current day, use the following formula

=TODAY()

To display the date and the time, you should use the following formula.

=NOW()

Remarks:

  • Parentheses are compulsory even if the function doesn't expect any parameter.
  • The cell is automatically formatted in date.

Split date and time

To return only the time, you must perform a deduction as explained in this article to separate the dates from the times.

Why use a function instead of writing the date?

Yes, why use a function when it is easier to enter the date directly in a cell? And even better with the shortcut CTRL+ ; (control key + semicolon)

Unfortunately, this date will not change any more because it is written in hard copy.

While writing either TODAY or NOW, the date will automatically change day after day 😍😍😍

Exercise with the function TODAY

What is the point of using this function in a workbook?

This function is very useful for automatically calculating date variances, such as

  • Birthday
  • Maturity
  • Payback period
  • Invoicing delay

In the following workbook, you have some customers who have not yet paid their bills (the date in column C is empty)

So, in case the cell containing the payment dates is empty, we will use the current date.

We will first test whether the payment date is empty or not.

=C5=""

If so, then we will perform the subtraction operation between the current date and the order date.

=TODAY()-B5

We put these two elements in an IF function

=IF(C5="",TODAY()-B5,"")

You can try to reproduce this formula in the workbook below or simply copy the formula already present in D4.

And what's happen tomorrow?

Well, since our formula uses the TODAY function, the value of the day will change on the following days.

So, the gap between the days will change every day 😎😍👍

Related articles


Have a look at these other articles that could help you in your work

Permanent link to this article: https://www.excel-exercise.com/now-today/


Leave a Reply

Your email address will not be published. Required fields are marked *