TODAY Function

---

Purpose of the Function

The TODAY function in Excel is used to display the current date without including the time component. It returns the current date based on your computer's system clock.

Syntax

• When you use the TODAY function in a cell or formula, it doesn't require any arguments. It simply displays the current date in the format of your Excel settings.

Practical Example

Step -01 : Call TODAY Function :

Select The Cell, Which You Want to Apply The Function And Write TODAY Function =TODAY In Selected Cell.

---

Step -02 : Enter TODAY Arguments :

We need to put the Brackets After Writing the TODAY Function as like Below picture showed.

---

Step -03 : Hit The Enter Key :

After Entering the Function, we need hit The Enter Key, The Excel returns the current Date and it is automatically updating the date when the worksheet changed or opened.

---

Step -04 : Customize The Date format :

If You want to customize the date format, You Are Able to customize. First, select the cell which you want to customize date. then, you need to click home ribbon, after that Click more number format. Then, select the format or customize the format as we want. indeed, I need first year second month third date so I can type (YYYY-MMM-DD) then hit the Enter key button. The following pictures will be showed as clear manner.

First

---

Second

---

Final

---

Similar to the NOW function, the TODAY function is dynamic. It updates every time the worksheet recalculates or when any change is made in the worksheet, ensuring that it always reflects the current date.

• Previous
• Next

Advance Excel 365

---

Introduction to Microsoft Excel

---

• What is Excel 365
• Microsoft Excel
• Microsoft Excel Formulas and Functions

Mathematical Functions

---

• SUM Function
• AVERAGE Function
• MAX Function
• MIN Function
• ROUND Function
• SUMIF Function
• COUNT Function
• COUNTA Function
• COUNTIF Function

Date And Time Functions

---

• NOW Function
• TODAY Function
• YEAR Function
• MONTH Function
• DAY Function
• HOUR Function
• MINUTE Function
• SECOND Function
• TIME Function

Text Functions

---

• CONCATENATE Functions
• LEN and MID Function
• TRIM Function
• TEXT Function
• LEFT Function
• RIGHT Function
• UPPER Function
• LOWER Function
• PROPER Function
• REPT Function
• EXACT Function

Logical Functions

---

• IF Function
• VLOOKUP Function