Date & Time Formats in Excel

September 13, 2022

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

Connect with Bill