By using Excel TODAY Function you can insert the current date in a cell. It will give you the current date which will update every time you recalculate your worksheet.
In the below example, I have deducted 1 day from today’s date to get yesterday’s date.
In the below example, I have used today function with other functions to get current month number, current year & current day.
You can use this function with other function to create some dynamic formulas. The best example is when you need the current date in your formula, you can use today and you don’t have to enter date every time.
A simple use of today is for calculating a person’s age.
To learn more about Excel TODAY Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.