IF forumla for fortnightly and monthly reminders

[fuzzfighter]

I have this spreadsheet that I am trying to create for payroll reminders for weekly, fortnightly and monthly clients. With the Weekly pay clients I need to trigger every Tuesday to be highlighted. With the fortnightly clients I need to trigger every second Tuesday and for the monthly clients I need to trigger every 14th of the month. I need a to create a IF forumla for this but I can't seem to figure it out. I have figured out the function for the weekly part (As in the picture)

but I need to add on to this condition for the fortnightly and monthly. Any help will be appreciated.

See currently layout of the excel in the Picture https://imgur.com/FBu5s3c

 

[jim may]

This seems to work - Highlite C2:E30, then C/F formula = "=C2=TRUE" without the quotes. with Yellow FILL
Excel 2010

	B	C	D	E
1	My Dates	= Tuesday	=2nd Tuesday	= 14th of Month
2	3/1/2019	FALSE	FALSE	FALSE
3	3/2/2019	FALSE	FALSE	FALSE
4	3/3/2019	FALSE	FALSE	FALSE
5	3/4/2019	FALSE	FALSE	FALSE
6	3/5/2019	TRUE	FALSE	FALSE
7	3/6/2019	FALSE	FALSE	FALSE
8	3/7/2019	FALSE	FALSE	FALSE
9	3/8/2019	FALSE	FALSE	FALSE
10	3/9/2019	FALSE	FALSE	FALSE
11	3/10/2019	FALSE	FALSE	FALSE
12	3/11/2019	FALSE	FALSE	FALSE
13	3/12/2019	TRUE	TRUE	FALSE
14	3/13/2019	FALSE	FALSE	FALSE
15	3/14/2019	FALSE	FALSE	TRUE
16	3/15/2019	FALSE	FALSE	FALSE
17	3/16/2019	FALSE	FALSE	FALSE
18	3/17/2019	FALSE	FALSE	FALSE
19	3/18/2019	FALSE	FALSE	FALSE
20	3/19/2019	TRUE	FALSE	FALSE
21	3/20/2019	FALSE	FALSE	FALSE
22	3/21/2019	FALSE	FALSE	FALSE
23	3/22/2019	FALSE	FALSE	FALSE
24	3/23/2019	FALSE	FALSE	FALSE
25	3/24/2019	FALSE	FALSE	FALSE
26	3/25/2019	FALSE	FALSE	FALSE
27	3/26/2019	TRUE	FALSE	FALSE
28	3/27/2019	FALSE	FALSE	FALSE
29	3/28/2019	FALSE	FALSE	FALSE
30	3/29/2019	FALSE	FALSE	FALSE

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =WEEKDAY(B2,1)=3 D2 =B2-DAY(B2)+1+2*7-WEEKDAY(B2-DAY(B2)+8-3)=B2 E2 =DAY(B2)=14 B3 C3 D3 E3 <tbody> </tbody>

<tbody>
</tbody>