Hi - Dave here.
Happy Friday!
How can you list the "Second Tuesdays" of each month with a formula?
This is a tricky problem in Excel, but you can solve it with one formula like this:
Don't be alarmed by this formula...it's not as bad as it looks! Most of the code is just set up, where we use the LET function to define variables that we'll need later. The real work is done in the last 4 lines. You can see the result in the worksheet below, which is configured to list "second Tuesdays" for the next 12 months:
[
Download the workbook and read the full explanation]
The link above provides a full explanation. This formula only works in the latest version of Excel. However, I've provided a different way to solve the problem in older versions of Excel on the second sheet. Download the workbook and try it out yourself.
The bottom line: New functions like LET, FILTER, SEQUENCE, BYROW, and LAMBDA are making it much easier to solve hard problems in Excel. They are game changers.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
