If you want to save the date that you updated a section of your sheet, type in the date instead of using TODAY(). Remember: Excel updates the value of TODAY() every time it recalculates your spreadsheet. If your project is due on November 10, 2014, count the number of days left before the due date by typing, “=DATE(2014,11,10)-TODAY()”. You can combine this with the DATE() function. TODAY() does not require any arguments it always returns the current date. To enter the current date, use the dynamic TODAY() function.
To enter a specific date in your spreadsheet use the DATE(year,month,day) function.
Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them.įortunately, Excel has all the functions to do the date arithmetic for you.Įntering a Date with the Year, Month and Day
