
Redha Akhund
Member
Members

Forum Posts: 9
Member Since:
March 28, 2021
March 28, 2021

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

Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019


Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 880
Member Since:
December 7, 2016
December 7, 2016

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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Sameh Alami, Riny van Eekelen, Donnacha Holly, Shoua Lee
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 188
Newest Members:
JUDY MLL
Scot Bailey
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Forum Stats:
Groups: 3
Forums: 24
Topics: 6548
Posts: 28672
Member Stats:
Guest Posters: 49
Members: 32834
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
