Need to sum up to 50 values until the sum is equal to or greater than a specific value

Hi,

I have to add actual varying amounts in a range of numbers located in one row/column until a specified target amount is reached, then populate a cell with the earliest date the target was met.
I also need to be able to change the targets and have a new date generated.

Ty