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
To display the date and the time, you should use the following formula.
- 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 TODAY or NOW in a worksheet?
This function is very useful for automatically calculating date gap, such as
- Payback period
- Invoicing delay
In the example at the bottom of the screen, 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 create a test if the date is empty or not. So here the result is TRUE or FALSE but we are going to change that.
If the date is empty (previous test = TRUE), then we will perform a subtraction between the current date, returns by TODAY, and the date of order.
We put these two elements in an IF function
Try in this embedded worksheet
Repro this formula in the following Excel workbook to see the result.