This is a straightforward conditional logic problem, and the #SPILL! error tells us exactly what is going wrong. The user has the right idea, adding 45 or 90 days based on a date threshold, but is likely writing the formula for the entire column at once without telling the spreadsheet where to stop. The solution is not a more complex formula; it is a more precise one.
The core of the issue is that modern spreadsheets try to be helpful by automatically filling an entire column when you write a formula in the top cell. That is the #SPILL! error: the formula wants to output results into every cell below, but something is blocking it. The fix is either to write the formula for a single cell and then drag it down, or to use a structured reference that only acts on rows with data. For this specific case, an IF formula with a simple date comparison works perfectly.
In cell C2, assuming the first request date is in B2, the formula is: `=IF(B2 What this user is experiencing is a common friction point: the tool is powerful, but it assumes you want to work at a scale you may not need. The #SPILL! error is not a failure of logic; it is a mismatch between the formula's intent and the current data layout. The practical takeaway is that you can often solve these problems by stepping back and asking, "What would I do for one cell?" Then replicate that logic. If you find yourself fighting errors like this frequently, it may be worth exploring spreadsheet tools designed to handle conditional logic more intuitively, where you describe the rule in plain language and the tool applies it row by row without the spill behavior. But for this specific request, the IF formula above will give you the due dates you need, starting today, with no errors.