Working with Data columns in Excel is many a times a necessity. There are various data tables that contains one or more date columns. There can be a need to work with the date column to do various calculations. One need can be to find the todays date. Excel has Now function that helps in finding current date and print the same. This article explains How to use Today function in Excel?
John has customer spend data for his company. He is looking forward to create a new column named “Todays Date”. The column shall contain todays date value.
Today formula in Excel
- Step 1: Today function does not require any parameters. Just the function along with parenthesis is good enough. Below is the syntax to print todays date value:
=TODAY()
- Step 3: Copy the cell K5 and paste the formulas to rest of the cells in the column. This will generate updated Todays Date column for whole table.
To get top certifications in Microsoft Excel and build your resume visit here. Also, you can read books listed here to build strong knowledge around Microsoft Excel.
Thus John is able to create a new column storing todays date value in the same. This can be helpful for further calculations in the table or any other analysis as well. The syntax of the function is the simplest.
Please visit our video tutorial to go through the example as well:
Share your feedbacks if you like the article. Like and share for more such content.
📬 Stay Ahead in Data Science & AI – Subscribe to Newsletter!
- 🎯 Interview Series: Curated questions and answers for freshers and experienced candidates.
- 📊 Data Science for All: Simplified articles on key concepts, accessible to all levels.
- 🤖 Generative AI for All: Easy explanations on Generative AI trends transforming industries.
💡 Why Subscribe? Gain expert insights, stay ahead of trends, and prepare with confidence for your next interview.
👉 Subscribe here:
Thank you for any other informative site. Where else could I am getting that type of information written in such a perfect manner? I have a project that I am simply now operating on, and I have been at the look out for such information.
Great post but I was wanting to know if you could write a litte more on this subject? I’d be very grateful if you could elaborate a little bit further. Bless you!