I'm creating a running target from a quarterly Total divided by known trading days
Current formula in I4 is =IF(H3<>"",I3+O$30,"")
H3 = Yesterday's Sales Numbers
I3 = Yesterdays Running Target
O30 = Required Daily Run Rate
Column C is a Date Column
I want the running target to show in I4 when it is Today (currently it shows a day in advance, so showing today the 2-Feb)