Formula: If condition is false don't change current cell value

[Magoosball]

I am trying to create an excel sheet that keeps track of my teams progress throughout the week. I put an example of what I currently have below as well as the formulas.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Complete[/TD]
[TD]Total[/TD]
[TD]12/31/18[/TD]
[TD]1/1/19[/TD]
[TD]1/2/19[/TD]
[TD]1/3/19[/TD]
[TD]1/4/19[/TD]
[TD]1/5/19[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]9[/TD]
[TD]10
[/TD]
[TD]=if(D$1=Today(),$B2/$C2,"")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Allie[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kim[/TD]
[TD]15[/TD]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ben[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]=if(I$1=Today(),$B5/$C5,"")
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I'm currently pulling reports from a database and pasting them into other sheets daily. The completed and total columns are calculated via formulas pulled from these other sheets. The issue that I'm having is that my formulas are erasing previous days data. For example, by the time I get to 1/5/19 the data in columns 12/31/18 - 1/4/19 is now erased.

Is it possible to update data for today without erasing previous data? Would it be possible with a UDF? Any suggestions are appreciated. Thank you!

Thank you in advance!

 

[RCBricker]

I am trying to create an excel sheet that keeps track of my teams progress throughout the week. I put an example of what I currently have below as well as the formulas.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Complete[/TD]
[TD]Total[/TD]
[TD]12/31/18[/TD]
[TD]1/1/19[/TD]
[TD]1/2/19[/TD]
[TD]1/3/19[/TD]
[TD]1/4/19[/TD]
[TD]1/5/19[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]9[/TD]
[TD]10
[/TD]
[TD]=if(D$1=Today(),$B2/$C2,"")[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Allie[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kim[/TD]
[TD]15[/TD]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ben[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]=if(I$1=Today(),$B5/$C5,"")
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I'm currently pulling reports from a database and pasting them into other sheets daily. The completed and total columns are calculated via formulas pulled from these other sheets. The issue that I'm having is that my formulas are erasing previous days data. For example, by the time I get to 1/5/19 the data in columns 12/31/18 - 1/4/19 is now erased.

Is it possible to update data for today without erasing previous data? Would it be possible with a UDF? Any suggestions are appreciated. Thank you!

Thank you in advance!

ok so the problem is that you have formulas active in each of these cells. So you will ALWAYS have data changing and not reflecting previous day's data. The current formula you have will continue to show values in previous days by simply changing it to

=IF(D$1<=TODAY(),$B2/$C2,"")

However, has you completed and total fields change, so will you values in active (today() and before) days. You will need to explore other options (possibly VBA) to do what I think you are trying to do.