Value in between Date Range

Need Assistance

Start Date End Date First Day of Calendar Months and etc
A1 B1 C1 D1 E1
1/1/2019 5/24/2019 1/1/2019 2/1/2019 3/1/2019

Today Date
A2 B2
1/29/2018 105.78


I need help correcting this code if possible or how to write it better.

Formula:

Please Login or Register  to view this content.

What i a trying to say: If the Start Date begins on or After the first day of the Month in C1 Then give me B2 AND If the end date is in that current month than give me B2 as well. If not in the date range leave blank

This is a contract with a start and end date. Need the Amortized amount 105.78 to go into the cell if the statement is true. This formula does not work if the start date begins on the Todays Date. It comes back with a blank status and i need it to populate 105.78

Normally I don't touch posts without a sample workbook attached because I am too lazy to set them up. This one was easy enough to set up. However, in the future, you will find people more willing to respond if a sample workbook is attached.

The magic formula is: =IF(AND(A2>=EOMONTH(C1,-1)+1,A2<=EOMONTH(C1,0)),B2,"")

Here is how I got there.

We need to know the beginning and end of the month.

The end of the month is =EOMONTH(C1,0) <- End of current month

The beginning of the month =EOMONTH(C1,-1) + 1 <- End of previous month plus a day.

Then it is a matter of determining if the date is between these two: >= Begin of month AND <= End of month.

Try pasting the following in F2 and then dragging across to O2:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Paste the following into cell F2: =IF(OR($C2>EOMONTH(F1,0),$B$2< EOMONTH(F1,-1)+1,$D2< EOMONTH(F1,-1)+1),"",$E2)
Let us know if you have any questions.