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.
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
This has been helpful. Appreciated the resolution.
Ok, will use only forum from next time. Sorry for trouble.
Cheers 🙂
