Yes, it really depends on if you need the date range to be inclusive or not. In my example, I need to include the end / finish date but if you don’t need the last date, yes, remove the +1.
Very timely video as I was looking for something to track my overall balances across all my accounts using transaction dates, where some accounts only have a few transactions per year and other accounts have lots, and I wanted to see what balance I have overall on any given day in the year. Thanks muchly
Great video. When you calculate the difference between dates, the +1 threw my figures off a bit. Once I took it off, it is perfect now!
Yes, it really depends on if you need the date range to be inclusive or not. In my example, I need to include the end / finish date but if you don’t need the last date, yes, remove the +1.
Very timely video as I was looking for something to track my overall balances across all my accounts using transaction dates, where some accounts only have a few transactions per year and other accounts have lots, and I wanted to see what balance I have overall on any given day in the year. Thanks muchly
Yes, that’s a good use case. Glad it helped.
Good video!
Great, glad you liked it.