Date & Time Formats in Excel Webinar | More4apps

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

On-Demand Webinar from More4apps

Hosted by: Bill Jelen, "MrExcel"

Webinar Abstract:

Many professionals who are tasked with updating data rely heavily on Microsoft Excel to simplify and streamline their processes. The problem though is the ever-changing budgets, price lists, item lists, and other needs that come with inventory transactions. What if you could use a single spreadsheet to help your organization create and update data quickly and efficiently, without disrupting business? Better yet, how could you create automatic formulas to customize your reporting parameters?  

Learn the tips & tricks with date & time formats in Excel when you watch our webinar!

Download and watch our webinar to learn:

  • 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
mrexcel and more4apps webinar april 27

Complete the short form below to get a copy of the webinar recording today!

Get to know "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. He has produced over 2400 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.