Date & Time Formats in ExcelSeptember 13, 2022
Automate Formulas for Budgets, Price Lists, and More
Date & time formats in excel is a webinar for professionals who work with data rely heavily on Microsoft Excel to simplify and streamline their processes.
The ever-changing budgets, price lists, item lists, and other needs that come with inventory transactions can cause problems.
There’s a way to eliminate those issues with a single Excel spreadsheet. Watch the webinar to learn how you can quickly process data by creating automatic formulas for your customized reporting parameters.
Get the webinar recording and materials today when you complete the short form below!
What you will learn from the webinar:
- Quick ways to put the current date or time in a cell
- Handling CSV files with dates in YYYYMMDD or D/M/Y format
- Converting text dates to real dates
- Formatting dates as month, quarter or weeks
- Calculate first of the month, end of the month
- Find the first Monday of the month
- Calculate workdays between two dates, excluding holidays
- The mysteriously hidden DATEDIF function
- Coercing an array from a start date and end date (i.e. how many Friday payrolls happen between now and the end of the year?)
- Showing time calculations that total to over 24 hours
Meet the Presenter
Bill Jelen – MrExcel
Bill is the host of MrExcel.com and the author of 64 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel Inside Out.
He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
Furthermore, Jelen has produced over 2,400 episodes of his Excel video podcast ‘Learn Excel from MrExcel’. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.
Previous Webinars Hosted by MrExcel
Tips to Perk up your Excel Workbooks with MrExcel
What’s new in Excel with MrExcel