Hi,
is there a way to write a lambda, probably using scan, to give a recurring accuulation by month for the Date format dd / mm/ yyyy
the abvoe is just working on a list of numbers and resets each time a one occurs, I could use this method, with a DAY function to get if = 1SCAN(0,G4:G19,LAMBDA(S,C,IF(OFFSET(C,,-1,,)=1,0*S+C,S+C)))
but not all the months are going to have 01 as there first date,
Just using excel would be ;so I need a way to trigger a reset at the min date of each month?SUMIF(Expanding date range ,">"&EOMONTH(@date ,-1),$F$3:F3)
Richard
examples attached.
Bookmarks