Conditional formatting formula that leaves the row clear if the date is 3 months from a date located in cell f2

chips

Board Regular
Joined
Oct 21, 2008
Messages
52
Hello

I have a checklist with tasks to perform on different dates. At the top of the column are dates and I would like the cells to be shaded if they do not equal a date every 3 months Falling on a friday with the First Friday being 7/1/2022

These are the formulas I have for weekly, fortnightly and monthly. I just need one for 3 monthly:

=IF(AND(WEEKDAY(XEW$2,2)=3,DAY(XEW$2)<7),TRUE(),FALSE())

=IF(WEEKDAY(B$2,2)>5,TRUE,FALSE)

=IF(NOT(WEEKDAY(B$2,2)=5),TRUE,FALSE)

=AND(ISODD(COUNTIF($B$1:B$1,"FRI")),B$1="FRI")

The first Friday is located in cell F2 with the date 7/1/2022

thank you in advance
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,215,013
Messages
6,122,690
Members
449,092
Latest member
snoom82

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top