Morning!
I am hoping that someone can help me with a formula that I am using to put together cumulative forecast numbers. The problem that I am running into with my current formula (graph data tab, cell b8) is that because this is a “Holiday” I need for it to pull the cumulative forecast number to the prior date. I have a defined range for holidays, but seem to be getting an error when I add an IF statement to look at the date in cell A8, and if it is a holiday, from my list of defined holidays, then take the number from the cell above. I hope that this makes sense, and appreciate any assistance you can provide/suggest.
=IF(A8=” “,””,(B7+LOOKUP(EOMONTH(BOM,0)+1,FDate,Frcst_JFunded)/FDIM))
