↑ Return to Date & Time

NOW & TODAY

It is possible in Excel to display the date in a cell and / or the current time (or called the system date).

Principle

To view the current day, use the following formula

= TODAY ()

Parentheses are required even if the function does not expect parameter. The cell is automatically formatted in date.

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

= NOW ()

Use

What is the interest to use these function in a worksheet? Well actually, these functions are extremely useful when you want to track gap dates.

In the following example, you want to show the difference in days when cells in column C are empty. In this case, you will do the subtraction between the current date (in B1) with the cell in column B. The advantage of this workbook is that each new day you open your workbook, the gap will be changed.

The formula used for the first cell D5 is .

=IF(C5="";$B$1-B5,"")

Enter in cell D6 the formula that allows you to return the number of days apart.

You can also create your own dates, such as the first and last day of the month corresponding to the system date (very useful for the Dashboard).



//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js

1 comment

  1. how to get facebook likes

    Hey I am so glad I found your weblog, I really found you by accident, while I
    was browsing on Yahoo for something else, Anyhow I am here now and would
    just like to say cheers for a fantastic post and a all round interesting blog (I also love the theme/design),
    I don’t have time to go through it all at the moment but I
    have bookmarked it and also added your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the excellent work.

    Check out my web blog – how to get facebook likes

Leave a Reply

%d bloggers like this: