Register
Log In
Unanswered
Home
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.
See Answer
November 8, 2013
Offline
Hi Jay,
Simply change from:
=AND($A2>=EOMONTH($A2,0)-7,WEEKDAY($A2)=5)
to:
=AND($A2>=EOMONTH($A2,0)-6,WEEKDAY($A2)=5)
Please use only one service, not all to post a question (Forum Or Comments Or Help Desk)
Thanks for understanding
Answers Post
Most Users Ever Online: 57
Currently Online:
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
