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)
Will that formula, as you have it written there, still be useful to you in 2021, or will you have to change the dates in the formula as time goes on?
Unless those dates are the relevant dates for the calculation you are wanting for all of time, I wouldn’t recommend putting the dates themselves into the formula like that.
Instead, you’ll probably want to have fields where you can define the date range for which you want to roll up the Payment amounts, so that you can change those dates as needed to view payment information across different time periods.