I came across this file recently, whilst browsing on my phone. In trying to re create it in Excel, I'm coming up with a "Calc" error on my Mac (which suggests an empty array), but on MS system shows "#Name error", and when evaluating shows "TODAY" as underlined and "the next evaluation will result in an error" message. Can anyone assist me here please?
=Let(start, EOMONTH(TODAY(), -1)+1, months,B5,n,B11,dow,B8, end,EDATE(start, months)-1, dates,SEQUENCE(end-start +1,1, start, 1), _
dates,FILTER(dates,TEXT(dates,"dddd") = dow), instance, BYROW(dates,LAMBDA(d, SUM((TEXT(d, "mmyy") = TEXT(dates,"mmyy"))* _
(d >= dates)))), FILTER(dates,instance = n))