Forum Discussion
Solved
Test if day of month falls between two dates
I have a spreadsheet that projects cash flows by week. Each column represents "The week of [date]" where [date] is the Monday of a week. Each row is a bill, such as rent or a subscription, that is to...
Like this?
=IF( (($B2>=DAY(C$1))+(EOMONTH(C$1,0)+$B2<(C$1+7)))*($B2<(DAY(C$1)+7))*($B2<=DAY(EOMONTH(C$1,0))), $A2,0)
Thanks for your quick response! The solution in your attached sheet still fails with the low numbered days (see weeks of 12/31/18, 1/28/19, 3/25/19).
please check attached file. alternatively you can use below formula
=($B2<=DAY(C$1))*($B2>=(DAY(C$1)-6))*$A2
Thank you, Erol.
Your sheet is only returning the first monthly due date. I need the sheet to return every monthly due date in the appropriate week.