Refer to a Day of the Month

[Peteor]

I am working on automating a friends finances in Excel. If my friend has income on the 1st of every month, and I have a date range pre-defined... I would like to automatically add a pre-defined amount if the 1st of the month falls within a date range.

E.G.

J1 = 8/29/2019
J2 = 9/5/2019

A1 = $10

B1 = $8
B2 = $2

I would like A1 to equal B1 unless the first of the month is within the range of J1 - J2. If the 1st of the month does fall within the range, I would like A1 to = B1+B2

How do I do this? I don't know how to just refer to a day of the month and not also the Month or Year within conditional statements.

 

[Tetra201]

Is this what you need?

=B1+B2*OR(DAY(J1)=1,MONTH(J2)>MONTH(J1))

 

[Peteor]

Just tested this. That was exactly what I needed. Thank you!