Hello there, I am wanting to auto generate the current date and time "NOW" function every time I enter data into another cell. You can adjust this format in the last step below. This is the complete guide to date and time in Excel. Drag down the dates by using the fill handle. Using the TODAY function in a calculation is useful when you need to track a time period dynamically. I don't know how to thank you enough for your Excel add-ins. If you want to input today's date in Excel that will always remain up to date, use one of the following Excel date functions:.
Format a date the way you want
Download and free trial Kutools for Excel Now!
Create a list of sequential dates
Merge the combined cells. Make sure to check it out! If there are date and date columns need to be combined, please apply any of the following formulas:. Expand your Office skills.