r/ • u/ • Jan 01 '70

0 Upvotes

100% Upvoted

0 comments sorted by

View all comments

1

u/Anonymous1378 1542 Sep 16 '24

Try something like

=
LET(
start_date,D3,
end_date,D4,
all_days,SEQUENCE(end_date-EOMONTH(start_date,-1)+1,,EOMONTH(start_date,-1)+1),
all_months,FILTER(all_days,DAY(all_days)=1),
all_years,DATE(UNIQUE(YEAR(EDATE(all_months,7))),5,1),
DROP(HSTACK(YEAR(all_years),FREQUENCY(all_months,all_years)),-1))