NOW & TODAY

NOW & TODAY
Last Updated on 15/05/2023
Reading time: 2 minutes

Presentation of the functions

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

We will use these functions to create workbooks such as

To view the current day, use the following formula

=TODAY()

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

=NOW()

NOW and TODAY
NOW and TODAY

Remarks:

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

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

  • Birthday
  • Payback period
  • Invoicing delay

In the example, you have some customers who have not yet paid their bills 😡 The date in column C is empty.

Exercise to calculate the gap between 2 dates

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.

=C5=""

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.

=TODAY()-B5

Finally, we put these two elements in an IF function

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

The function TODAY will update the result every day

6 Comments

  1. Mary Ann D. Gelledo
    17/05/2021 @ 12:58

    how did you get 57 under the gap column?

    Reply

    • Patrick
      01/02/2022 @ 11:28

      Try , b1 is 06/01/2019 minus b5 which is 06/11/2019.

      Reply

  2. David
    13/04/2018 @ 23:54

    How can I use =now() to show date and standard time, not military time?

    Reply

    • Frédéric LE GUEN
      17/04/2018 @ 05:02

      It depends of the local setting of windows (regional format)

      Reply

  3. Sascha Gallardo
    11/02/2018 @ 07:49

    I need a formula that checks whether today's date is at the beginning of the week or in the middle. I'm creating a weekly attendance sheet that's being printed. Sometimes I need to print it in the middle of the week, and the sheet starts with that day's name and date: What I have now is this (showing three cells of each)

    =TEXT(WEEKDAY(C3;1);"dddd") || =TEXT(WEEKDAY(E3;1);"dddd") || =TEXT(WEEKDAY(G3;1);"dddd")
    TODAY() || TODAY()+1 || TODAY()+2

    Can you help?

    Reply

    • Sascha Gallardo
      11/02/2018 @ 07:55

      BTW, nice touch to use my computer's settings to show the actual formula!

      Reply

Leave a Reply

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

NOW & TODAY

Reading time: 2 minutes
Last Updated on 15/05/2023

Presentation of the functions

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

We will use these functions to create workbooks such as

To view the current day, use the following formula

=TODAY()

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

=NOW()

NOW and TODAY
NOW and TODAY

Remarks:

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

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

  • Birthday
  • Payback period
  • Invoicing delay

In the example, you have some customers who have not yet paid their bills 😡 The date in column C is empty.

Exercise to calculate the gap between 2 dates

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.

=C5=""

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.

=TODAY()-B5

Finally, we put these two elements in an IF function

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

The function TODAY will update the result every day

6 Comments

  1. Mary Ann D. Gelledo
    17/05/2021 @ 12:58

    how did you get 57 under the gap column?

    Reply

    • Patrick
      01/02/2022 @ 11:28

      Try , b1 is 06/01/2019 minus b5 which is 06/11/2019.

      Reply

  2. David
    13/04/2018 @ 23:54

    How can I use =now() to show date and standard time, not military time?

    Reply

    • Frédéric LE GUEN
      17/04/2018 @ 05:02

      It depends of the local setting of windows (regional format)

      Reply

  3. Sascha Gallardo
    11/02/2018 @ 07:49

    I need a formula that checks whether today's date is at the beginning of the week or in the middle. I'm creating a weekly attendance sheet that's being printed. Sometimes I need to print it in the middle of the week, and the sheet starts with that day's name and date: What I have now is this (showing three cells of each)

    =TEXT(WEEKDAY(C3;1);"dddd") || =TEXT(WEEKDAY(E3;1);"dddd") || =TEXT(WEEKDAY(G3;1);"dddd")
    TODAY() || TODAY()+1 || TODAY()+2

    Can you help?

    Reply

    • Sascha Gallardo
      11/02/2018 @ 07:55

      BTW, nice touch to use my computer's settings to show the actual formula!

      Reply

Leave a Reply

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