Snasui Excel Forum

Hi Dear
I have set up a day, month and year in separate columns.i put as below
A2:30
B2:4
C2:2021
It would give 1 to 30 for the month of April (4)
as I change the parameters in A2 thru C2 the days of week would change.

Thanks

A4=IF(A$2<ROWS(A$4:A4),"",DAY(DATE(C$2,B$2,ROWS(A$4:A4))))

Thanks .once more without inputing in A2 just input Month in B2 and Year in C2 ,Is it possible to return 1 to 30 in A2 by drop down list?