About this episode

This episode explains how to simplify Excel date calculations using a powerful custom function.

What if you could simplify Excel date calculations with one powerful custom function ? Well , t his episode explains how . You'll learn: How to handle different date increments including days, weeks and months in one function Using the SWITCH function to create a lookup table How the LAMBDA function can be deployed Best practice tips for this custom function Listen now to improve your Excel skills. Host: Neale Blackwood CPA. He has more than 20 years of experience as a Microsoft Excel educator and is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants . For more, check out the accompanying video for this episode. R ead more of Neale's Excel articles on INTHEBLACK . Loving this content? D on ' t forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community . Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest ? Head to CPA Australia's YouTube channel . And don't forget to subscribe to the channel. You can find a CPA at our custom portal on the CPA Australia website. CPA Australia publishes four podcasts…

More episodes of Excel Tips

• Template tips to boost workflows · April 30, 2026 · 8 min
• Master your messy data · March 1, 2026 · 6 min
• Build Better Excel Models · February 1, 2026 · 12 min
• Smarter, faster, easier: Here's what's new in Excel · December 31, 2025 · 14 min
• Unlock 7 underused Excel features you still need today · November 30, 2025 · 16 min
• How to simplify complex calculations with custom functions · November 2, 2025 · 8 min

Explore listener stats, chart rankings, contacts and more on the Excel Tips podcast page.