top of page
Search

Easy Way to Get the Current Date and Time on Your Excel Sheet



Here's a step-by-step guide on how to find the current date in Excel using the formula =TODAY():


  1. Open Your Excel Workbook:

  • Launch Microsoft Excel and open the workbook where you want to find the current date.

  1. Select the Cell:

  • Click on the cell where you want the current date to appear.

  1. Enter the Formula:

  • Type or paste the formula =TODAY() into the selected cell.

  1. Press Enter:

  • After entering the formula, press the "Enter" key on your keyboard.

  1. View the Current Date:

  • The cell will now display the current date.

The =TODAY() formula is a dynamic function, so the date will automatically update every day to reflect the current date whenever you open the workbook or recalculate formulas.


 
 
 

Comments

bottom of page