u/MrSteve094

I work in a large database of parts numbers (xxxx-xxx01, xxxxx-xxx02, and so on).

Each of these parts have changes made to them, but with different start dates. therefore, I need a formula that can recognise a date and only sum the months included within that range.

for example:

xxxxx-xxx01 (start: Apr) = sum of all months Apr to March

the next line may be;

xxxxx-xxx01 (start: Jul) = sum of all months Jul to March.

I have a diagram of this prepared if you need me to show you via DM (I can't upload due to sub Reddit rules).

how can I do this?