![]() “=A1-A2” returns 5, because December 10 is five days before December 15.Similarly, you can subtract two dates to get the number of days between them. Note that the number that you add or subtract is always the number of days. ![]() “=A2-3” returns December 7, 2014, which is 3 days before December 10.“=A1+10” returns December 25, 2014, which is ten days after December 15.To add a number of days to a date, or to subtract a number of days from a date, just add or subtract the number of days. 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |