reciecup2000
New Member
- Joined
- Dec 16, 2005
- Messages
- 1
I am trying to come up with a if then formula for a pay calcalculation based on the date.
We have a list with bills that show the due date only so it will only say 6 if its due on the 6th of the month.
The pay schedule however is on a rolling 2 week schedule. I have pulled out the date of the week to do a formula that says if the due date is between the dates then put the amount from another column. However that doesnt work when the month changes and the next date is less then the previous date.
How do I fix that.
1 People's Choice 724
1 Homeq 567
1 Alvin's 57
7 Aspire 120
30 13
Due Date Bill 12/30/2005 Due Date Bill 1/13/2006
Edited by Von Pookie ~ fixed formula display
We have a list with bills that show the due date only so it will only say 6 if its due on the 6th of the month.
The pay schedule however is on a rolling 2 week schedule. I have pulled out the date of the week to do a formula that says if the due date is between the dates then put the amount from another column. However that doesnt work when the month changes and the next date is less then the previous date.
How do I fix that.
1 People's Choice 724
1 Homeq 567
1 Alvin's 57
7 Aspire 120
30 13
Due Date Bill 12/30/2005 Due Date Bill 1/13/2006
Code:
iF(OR($A8=N$6,AND($A8>N$6,$A8<R$6)),$B8,"")
Edited by Von Pookie ~ fixed formula display