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

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

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

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

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