IF forumla for fortnightly and monthly reminders

fuzzfighter

New Member
Joined
Mar 3, 2019
Messages
1
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)
FBu5s3c
but I need to add on to this condition for the fortnightly and monthly. Any help will be appreciated.
FBu5s3c
See currently layout of the excel in the Picture https://imgur.com/FBu5s3c
 

Some videos you may like

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
Joined
Jul 4, 2004
Messages
7,484
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>
 

Watch MrExcel Video

Forum statistics

Threads
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.
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
Top