To view the current day, use the following formula
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.
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 .
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).