financefinance
New Member
- Joined
- Dec 29, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
In cell B10 I have a value of $10,000
In cell C10, I have the value 26
In this example, I am intending to create a schedule of payments in whichever week the 26th falls in each month throughout the year
In cell D6 I have the week ending date 12/25/2020
In cell E6 I have the week ending date 1/1/2021 (in this example, I am expecting the payment to be in the week in 1/1/21)
In cell F6 I have the week ending date 1/8/2021 ... and so on
I tried the following formulas, but neither is resulting a value in the week of 1/1/2021 (I understand why I am not getting the value; I am not sure of the fix)
=IF(AND($C10>(DAY(D$6)-7),$C10<=DAY(D$6)),$B10,0)
=IF(AND(DATE(YEAR(D$6),MONTH(D$6),$C10)>(D$6-7),DATE(YEAR(D$6),MONTH(D$6),$C10)<=D$6),$B10,0)
Prefer a formula solution. Appreciate your help!
In cell C10, I have the value 26
In this example, I am intending to create a schedule of payments in whichever week the 26th falls in each month throughout the year
In cell D6 I have the week ending date 12/25/2020
In cell E6 I have the week ending date 1/1/2021 (in this example, I am expecting the payment to be in the week in 1/1/21)
In cell F6 I have the week ending date 1/8/2021 ... and so on
I tried the following formulas, but neither is resulting a value in the week of 1/1/2021 (I understand why I am not getting the value; I am not sure of the fix)
=IF(AND($C10>(DAY(D$6)-7),$C10<=DAY(D$6)),$B10,0)
=IF(AND(DATE(YEAR(D$6),MONTH(D$6),$C10)>(D$6-7),DATE(YEAR(D$6),MONTH(D$6),$C10)<=D$6),$B10,0)
Prefer a formula solution. Appreciate your help!