Need help with a very specific If/Then formula

[dclaudio]

I am trying to get an estimated budget number each month.  Here is what the relevant data looks like:

	Week 1 (Days 1-7)	Week 2 (Days 8-14)	Week 3 (days 15-21)	Week 4 (Days 22-28)	Week 5 (Days 29-31)
2023 Actuals	100	-	-	-	-
2023 Esitmate	100
2022 Actuals	200	190	202	250	198

What I want is to calculate the "2023 Estimate" using the formula [(Month to date actuals/same period last year actuals)*same period last year actuals] ONLY if the current week is not complete.  When I have 2023 actuals, I would like that value to appear in the 2023 estimate cell for that week.  Im thinking something like (for week 2) if 'pst'(settlementdate) days < 15, then use the above formula.  ELSE it shoudl = 2023 actuals for the same period.  Help!

[lbendlin]

Read about COALESCE