In this half-day course we run through the many powerful date functions in Excel, including anniversaries, forecasting, fiscal years, elapsed time, and more. How much time is left on that Certificate of Deposit, when do you have to pay that traffic ticket, and how old is grandma, really?
AUDIENCE AND PREREQUISITES
Schedulers, planners, managers who deal with personnel, financial planners, anyone who works with time and dates.
Numbers and Dates in ExcelDate formatsEntering Dates typing techniques ambiguous dates local settings autofillDate Math adding and subtracting datesExtracting elements of dates day of the week fiscal quarters fiscal years first and last day of the month week ending on ...Holidays compute any American holiday Anniversaries birthdaysCreative Narratives text formatting DATEDIFF function