- Mar 18
Excel LET Function and Other Functions
- Neale Blackwood
- 0 comments
In my previous post I created a formula that calculates the month number for a financial year. That formula used the MONTH function four times. I thought I would share a technique you can use to define functions as a variable in LET function.
Sign up to hear about free Excel training.
I won't share your email with anyone.
1 min read
The image below shows the formula from my previous post.
You can check out the previous post at the link below.
Link.
Variables can be used to capture a value or a range. They can also be used to capture a function.
The formula below works in the same way.
=LET(fn,MONTH,fn($A6)-fn(B$2)-(fn($A6)<=fn(B$2))*-12)The fn variable captures the month function and then you can use the fn variable to replace all the month functions in the formula.
