First, I need Excel to work out how many full months have elapsed so far, so that when I use OFFSET, I can use this figure to tell Excel how far from the starting point I need to offset.

Learn how to use Microsoft Excel step by step in this beginner-friendly tutorial. If you're new to Excel or want to understand the basics, this video shows you how to get started using Excel right ...

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.