I have beat my head against the wall with this one. I really hope someone can help here. To Completely summarize what I am trying to do....
{
If it is Peter's pay-week, N4 equals Y1
If it is Casey's pay-week, N4 equals Y1 + Y2
}
-----------------------------------------------------------------
Peter is paid weekly, and Casey is paid Bi-Weekly.
Peter and Casey are both paid on Thursdays.
I know how to make it work THIS WEEK with the following (which would need to be edited to apply here; I copy/pasted from the forum I found it on):
=IF(ABS(TODAY()-WEEKDAY(TODAY()-1)+3-D2)<=3,G2,150)
How do I make the formula referenced above work also for future date ranges rather than just THIS WEEK? I have the ranges I am interested in considering in column J
{
If it is Peter's pay-week, N4 equals Y1
If it is Casey's pay-week, N4 equals Y1 + Y2
}
-----------------------------------------------------------------
Peter is paid weekly, and Casey is paid Bi-Weekly.
Peter and Casey are both paid on Thursdays.
I know how to make it work THIS WEEK with the following (which would need to be edited to apply here; I copy/pasted from the forum I found it on):
=IF(ABS(TODAY()-WEEKDAY(TODAY()-1)+3-D2)<=3,G2,150)
How do I make the formula referenced above work also for future date ranges rather than just THIS WEEK? I have the ranges I am interested in considering in column J
Last edited: