Forum Discussion

dclaudio's avatar
dclaudio
Frequent Visitor
3 years ago

Need help with a very specific If/Then formula

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 Actuals100----
2023 Esitmate100    
2022 Actuals200190202250198

 

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!

1 Reply