Highline Excel 2013 Class Video 31: Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More
Download workbook: http://people.highline.edu/mgirvin/Al...
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
Topics in this video:
1. TODAY function to put in today's date so that it updates each day (00:19 min)
2. NOW to put in today's date and time so that it updates each day (00:38 min)
3. Keyboard for hard coding today's date (Ctrl + ;) and time (Ctrl + Shift + ;) (00:48 min)
4. YEAR and MONTH and DAY functions to add extra columns to data sets so that you can perform data analysis. (01:25 min)
5. SUMIFS and Helper Column to add sales by Year. (02:33 min)
6. EOMONTH function (03:25 min)
7. EDATE function to calculate same day next month (04:31 min)
8. DATE and YEAR and MONTH and DAY functions to calculate same day next month (05:34 min)
9. EDATE function to calculate Vest Date (07:30 min)
10. DATE and YEAR and MONTH and DAY functions to calculate Vest Date (07:57 min)
11. DATE, LEFT, MID, RIGHT functions to create serial number date from database output date (eight consecutive number output) (08:19 min)
12. TEXT functions and Forward Slash to Insert Characters into Number Format to create serial number date from database output date (eight consecutive number output) (09:38 min)
Convert year month date number to a serial number.
Watch video Highline Excel 2013 Class Video 31: Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More online without registration, duration hours minute second in high quality. This video was added by user excelisfun 07 November 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 28,146 once and liked it 152 people.