Webinar Recordings

Date & Time Formats in Excel

Automate Formulas for Budgets, Price Lists, and More

On-Demand Webinar

Date & Time Formats in Excel is a webinar for professionals who work with data and 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.

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 Jelen 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

On-demand webinar

Tips to Perk up your Excel Workbooks with MrExcel

Watch the webinar >

On-demand webinar

What’s new in Excel with MrExcel

Watch the webinar >

Tips to Perk up your Excel Workbooks with MrExcel
More4apps partners with MrExcel to host What's New in Excel.

Brochure

Date & Time Formats in Excel: Automate Formulas for Budgets, Price List, and More

Get the brochure >

Date & Time Formats in Excel: Automate Formulas for Budgets, Price Lists, and More

Keep an eye on our events page for upcoming MrExcel webinars, browse our Resource Library for additional materials or connect with an expert today!

Connect with an expert

connect with your excel experts