need info to display only after date is current and stay there

[Cindyt]

Hi - I need your expert help. This should be easy-but cannot figure it out

I have a simple spreadsheet that keeps track of "items in", "items out" and
"carry over" by day. Since I do it by month, the formula shows the "carry
over" number all through the end of the month. I do not want it to show up
until the date is current, and then not go away on the previous columns.
ie.
Date 4/1/10 4/2/10 4/3/10 4/4/10 4/5/10 4/6/10 4/7/10
Work in 10 10 12
Work out 8 5 18
Carry Over 2 7 1 1 1 1 1

Any help would be greatly appreciated! ct

 

[Bob I]

Perhaps Conditional Formatting that makes Font White if "today() > cell
with Date.

 

[BSc Chem Eng Rick]

Cindy,

In carry over formula, try:
=if(today()>=B1,B2-B3,"")
Where B1 is your Date cell.

 

[Bob I]

Typo, should be <

Perhaps Conditional Formatting that makes Font White if "today() > cell
with Date.

 

[Cindyt]

Thank you - worked like a charm!

Cindy,

In carry over formula, try:
=if(today()>=B1,B2-B3,"")
Where B1 is your Date cell.