# IF forumla for fortnightly and monthly reminders

#### fuzzfighter

##### New Member
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

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### jim may

##### Well-known Member
This seems to work - Highlite C2:E30, then C/F formula = "=C2=TRUE" without the quotes. with Yellow FILL
Excel 2010
BCDE
1My Dates= Tuesday=2nd Tuesday= 14th of Month
23/1/2019FALSEFALSEFALSE
33/2/2019FALSEFALSEFALSE
43/3/2019FALSEFALSEFALSE
53/4/2019FALSEFALSEFALSE
63/5/2019TRUEFALSEFALSE
73/6/2019FALSEFALSEFALSE
83/7/2019FALSEFALSEFALSE
93/8/2019FALSEFALSEFALSE
103/9/2019FALSEFALSEFALSE
113/10/2019FALSEFALSEFALSE
123/11/2019FALSEFALSEFALSE
133/12/2019TRUETRUEFALSE
143/13/2019FALSEFALSEFALSE
153/14/2019FALSEFALSETRUE
163/15/2019FALSEFALSEFALSE
173/16/2019FALSEFALSEFALSE
183/17/2019FALSEFALSEFALSE
193/18/2019FALSEFALSEFALSE
203/19/2019TRUEFALSEFALSE
213/20/2019FALSEFALSEFALSE
223/21/2019FALSEFALSEFALSE
233/22/2019FALSEFALSEFALSE
243/23/2019FALSEFALSEFALSE
253/24/2019FALSEFALSEFALSE
263/25/2019FALSEFALSEFALSE
273/26/2019TRUEFALSEFALSE
283/27/2019FALSEFALSEFALSE
293/28/2019FALSEFALSEFALSE
303/29/2019FALSEFALSEFALSE

<tbody>
</tbody>
Sheet1

Worksheet Formulas
CellFormula
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>

Replies
1
Views
198
Replies
0
Views
165
Replies
3
Views
209
Replies
3
Views
211
Replies
1
Views
69

1,127,035
Messages
5,622,329
Members
415,892
Latest member
ChloeLM

### 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.

### Which adblocker are you using?

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

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