Log In
Register
Home
March 28, 2021
Offline
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
See Answer
Trusted Members
December 20, 2019
Offline
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
Answers Post
VIP
Trusted Members
December 7, 2016
Offline
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
1 Guest(s)
