_excel-video-167-using-today-date-year-and-month-to-automatically-update-a-rolling-report.jpg "Excel Video 167 Using TODAY, DATE, YEAR, and MONTH to Automatically Update a Rolling Report from add and subtract date and time calculator Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 2 min 48 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
Description:
When we last left our heroes in Excel Video 166, we had a clever formula that automatically updated after entering data in one cell.In Excel Video 167, we’ll go one step further and automatically calculate that cell as well.When you open the spreadsheet now, all of the cells will have the months you need.To get the first cell to automatically update, we’ll combine some functions we just learned, TODAY, DATE, YEAR, and MONTH.nnHere’s the formula for the first cell (that references TOD
When we last left our heroes in Excel Video 166, we had a clever formula that automatically updated after entering data in one cell.In Excel Video 167, we’ll go one step further and automatically calculate that cell as well.When you open the spreadsheet now, all of the cells will have the months you need.To get the first cell to automatically update, we’ll combine some functions we just learned, TODAY, DATE, YEAR, and MONTH.nnHere’s the formula for the first cell (that references TOD
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_how-to-add-or-subtract-months-from-a-date-in-excel-microsoft.webp "How2TechTips")
_operation-valentine-new-latest-south-hindi-dubbed-movie-full-hd.webp "Pilots from the Indian Air Force embark on a courageous mission, facing one of the biggest and deadliest aerial attacks that the country has ever witnessed.")
_meet-the-math-facts-addition-amp-subtraction-level-2-free-124-preschool-prep-company.webp "Preschool Prep Company")
⏲ 1 hour 3 minutes 26 seconds 👁 3.4M
_add-or-subtract-years-from-a-date-in-excel.webp "TeachExcel")
_how-to-add-or-subtract-time-in-excel-calculate-hours-and-minutes-for-accurate-timekeeping.webp "Sharon Smith")
⏲ 8 minutes 24 seconds 👁 31.4K
_how-to-add-months-to-or-subtract-months-from-a-date-in-excel.webp "Chester Tugwell")
_fox39s-farmer-wants-a-wife-tackles-the-age-gap-head-on.webp "Experience the drama and romance in Season 2 Episode 12 of Farmer Wants a Wife with the riveting 'Age Gap' clip. Hosted by the charismatic Jennifer Nettles, delve into the highs and lows of love on FOX, available for streaming now!<br/><br/>Farmer Wants a Wife Host:<br/><br/>Jennifer Nettles<br/><br/>Stream Farmer Wants a Wife Season 2 now on FOX!")
_meet-the-math-facts-addition-amp-subtraction-level-1-free-124-preschool-prep-company.webp "Preschool Prep Company")
⏲ 59 minutes 22 seconds 👁 11.9M
_how-to-add-or-subtract-months-from-a-date-in-excel-microsoft.jpg)
_operation-valentine-new-latest-south-hindi-dubbed-movie-full-hd.jpg)
_meet-the-math-facts-addition-amp-subtraction-level-2-free-124-preschool-prep-company.jpg)
_add-or-subtract-years-from-a-date-in-excel.jpg)
_how-to-add-or-subtract-time-in-excel-calculate-hours-and-minutes-for-accurate-timekeeping.jpg)
_how-to-add-months-to-or-subtract-months-from-a-date-in-excel.jpg)
_fox39s-farmer-wants-a-wife-tackles-the-age-gap-head-on.jpg)
_meet-the-math-facts-addition-amp-subtraction-level-1-free-124-preschool-prep-company.jpg)
![[+]](/images/menu.gif){kind=small}