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 post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...