jay_excel
Member
Members
Forum Posts: 11
Member Since:
July 23, 2017
July 23, 2017
Offline
Hello Experts,
I've got a formula here for conditional format, to highlight only the last Thursday's of every month for a period of 5 years from today. However, the months, which are ending with Thursday's, the formula is considering to highlight the last two Thursday's of those months. Examples of such months are Aug 2017, November 2017, May 2018, January 2019, February 2019, etc.
The formula is as below and please find the attached sample file for reference.
=AND($A2>=EOMONTH($A2,0)-7,WEEKDAY($A2)=5)
Kindly help.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kang-Ting Lee
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 289
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Sugata Maity
Karen McCarron
Amanda Zibell
Kevin Sanderson
wer klaus
Richard Gower
Sanket Rathod
Tung Vo
chutima thongnan
David Ball
Forum Stats:
Groups: 3
Forums: 24
Topics: 6877
Posts: 30140
Member Stats:
Guest Posters: 49
Members: 33695
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —