Skip to content
Global sound
Excel Tips

Excel Tips

Increment dates easily in Excel

· 7 min

Show notes

What if you could simplify Excel date calculations with one powerful custom function?

Well, this 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…

Website: 08fe4945-be1f-4a9d-a023-db879e2b8021.libsyn.com

Live, last hour: 2,111 songs on 7,706 stations in 142 countries

Discover the world through radio

More ways to discover (9)

Heard something good? Save it, or open it straight away in Spotify.

Radio 538 luisteren - Live!Popular right now