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…
People in this episode
Host: Neale Blackwood CPA
Topics covered
- Excel date calculations
- custom functions
- SWITCH function
- LAMBDA function
- best practices
- Excel skills
Keywords
- Excel
- date increments
- SWITCH function
- LAMBDA function
- custom function
- best practices
- Excel skills
Mentioned in this episode
Organizations: CPA Australia
Books & works: Advanced Excel Reporting for Management Accountants
More episodes of Excel Tips
- Template tips to boost workflows · May 1, 2026 · 8 min
- Master your messy data · March 2, 2026 · 6 min
- Build Better Excel Models · February 2, 2026 · 12 min
- Smarter, faster, easier: Here's what's new in Excel · January 1, 2026 · 14 min
- Unlock 7 underused Excel features you still need today · December 1, 2025 · 16 min
- How to simplify complex calculations with custom functions · November 3, 2025 · 8 min
Explore listener stats, chart rankings, contacts and more on the Excel Tips podcast page.