Highline Excel 2013 Class Video 31


Date Functions: EDATE, EOMONTH, DATE, YEAR, MONTH, DAY, More

DESCRIPTION

Topics in this video:
1. TODAY function to put in today’s date so that it updates each day.
2. NOW to put in today’s date and time so that it updates each day.
3. Keyboard for hard coding today’s date (Ctrl + 😉 and time (Ctrl + Shift + ;).
4. YEAR and MONTH and DAY functions to add extra columns to data sets so that you can perform data analysis.
5. SUMIFS and Helper Column to add sales by Year.
6. EOMONTH function.
7. EDATE function to calculate same day next month.
8. DATE and YEAR and MONTH and DAY functions to calculate same day next month.
9. EDATE function to calculate Vest Date.
10. DATE and YEAR and MONTH and DAY functions to calculate Vest Date.
11. DATE, LEFT, MID, RIGHT functions to create serial number date from database output date (eight consecutive number output).
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).

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 187 times – 21 MB




Be the first to comment

Leave a Reply