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

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

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

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

Cindyt wrote:

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

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

Cindy,

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

--
If this helps, please click "Yes"
<<<<<<<<<<<


"Cindyt" wrote:

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

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

Typo, should be <

Bob I wrote:

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

Cindyt wrote:

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

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

Thank you - worked like a charm!

"BSc Chem Eng Rick" wrote:

Cindy,

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

--
If this helps, please click "Yes"
<<<<<<<<<<<


"Cindyt" wrote:

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