Hi there, Im looking for a bit of help with a formula. I’ll try and explain it as best I can…
I have six fields as follows:

1st Payment Date (date type) (e.g 1st Jan 2020)

1st Payment Amount (Currency) (e.g £500)

2nd Payment Date (date type) (e.g 3rd Jan 2020)

2nd Payment Amount (Currency) (e.g £500)

3rd Payment Date (date type) (e.g 5th Jan 2020)

3rd Payment Amount (Currency) (e.g £500)
What I would like to do is create another field with a formula that would basically sum all the payment dates which fit within a specific date range (an example date range relating to the fields above would be the 1st to the 31st Jan 2020)
Would anyone be able to help with this?
Thanks in advance!