I have drop list for Month and Year.
My challenge is, To select any month for any Year and Date to Start From Sunday onwards.
The second challenge is, I have Table and on column E8 "Date" has formula. If I want to add more name it does not update the formula. My excel setting is on Automatic refresh.
Please advise..
Thanks Redha
if i have understood correctly you want the date of the first sunday in the month selected?
Does this work for you?
=D2+MATCH("Sunday",TEXT(ROW(INDIRECT(D2&":"&D2+6)),"DDDD"),0)-1
Hello,
An alternative formula to get the date for the first Sunday in the month. Depending on your system date setting you might need to change the last number in the formula. More info about this can be found here.
=DATE(E4,MONTH(E2&1),7)-WEEKDAY(DATE(E4,MONTH(E2&1),1)-1,2)
Br,
Anders
Thank you so much, works perfectly.
