Current Date in Microsoft Excel

In this tutorial, you will learn how to get current date in Microsoft Excel using TODAY and NOW functions in Excel.

TODAY, NOW and Static date and time are the functions that will help us get the desired result.

TODAY function in Excel

This function is =TODAY(). By simply entering this you’ll get the current date.

Current Date in Excel

NOW function in Excel

This function gives both the current date and time, =NOW().

Current Date in Excel

Static Date and Time in Excel

To make the current time date and time as static use control keys Ctrl+; . Using this control key makes the current date and time static.

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021