Change this formula from monthly to biweekly

[kookejar]

Hello,

I am using the Dues Tracker template from Microsoft to track dues in my organization however, dues are paid biweekly for the pay period ending. I do not know how to change this formula from monthly to biweekly and any help would be greatly appreciated...

=IFERROR(IF([@[First OP Date]]<>"",([@[Months member]]*MonthlyDues)-[@[Total Paid]],""),"")


Thanks,

Kookejar

 

[BSALV]

your data isn't a table, a listobject, so the formulas as shown for a table are invalid.
Then normal formulas

Map1
	A	B	C	D	E	F
9		Per pay period	3,5
10
11	SSN	Last Name	First Name	First OP date	Total paid	Total due
12	12232345	MARLEY	BOB	15/jan	0	10,5
Blad1

Cell Formulas
Range	Formula
F12	F12	=IF(D12<>"",TRUNC((TODAY()-D12)/14)*$C$9-E12,"-")

 

[kookejar]

Hello Bsalv,

First off, let me say thanks so much. I do appreciate you...!

Here is the latest:

After I sent you the last message and researching a bit the column and table part of your question, I simply clicked the dropdown "Format as Table/chose a table/pasted in the formula/pressed enter and things began to function properly with no error. I am going to get with another one of my colleagues to check the time frame regarding our pay periods. I want to be sure that the time frame is correct.

Again, thanks so much and I may have additional questions in the next few days revolving around getting the pay period correct. If I can make a donation somewhere for your help, please do not hesitate to let me know where. If that request is inappropriate, I apologize. This is still a work in progress and a great start...

Kind Regards,

Kookejar

 

[BSALV]

you're welcome and the help you get here is free of charge.

 

[kookejar]

Understood Bsalv...Thanks again...!