Forum Discussion
Solved
Every other Friday
Hi, I wanted to find every other Friday and want to label it as "OFF". Could someone pls help me. Thanks
In column G:
=IF(AND(G$6="Fri", ISODD(COUNTIF($G$6:G$6, "Fri"))), "OFF", "")
Fill to the right.
Hi Santosh, thanks. Could you pls use weekday formula. Because i have to use for other days also.
In column G:
=IF(AND(G$6="Fri", ISODD(COUNTIF($G$6:G$6, "Fri"))), "OFF", "")
Fill to the right.
- HI Hans, thank you so much, it worked perfect!!