How to get dates based on a month

Originally Posted by Fluff13

How about in C6 only

Formula:

=LET(d,DATE(E3,MONTH("1/"&E2),1),SEQUENCE(DAY(EOMONTH(d,0)),,d))

clear all cells below C6 first

I get THE FIRST ARGUMENT OF LET MUST BE A VALID NAME

Also does this formula take in consideration the Year?