Delete Cell Function

[roy.okinawa]

I currently have column H, Days In Shop, calculating the days from current
date to column W, Date Received: =Today()-W31

What I need is a formula that will also delete/blank/terminate that cell in
column H once a date is entered in column Y.

H W Y

3 11/20/2005
11/20/2005 11/23/2005

Thanks.

 

[Gary''s Student]

=IF(Y1="",today()-W1,"") in H

 

[roy.okinawa]

I get 38679 in cell H1. It should be blank since I have a date in Y1.

 

[Dave Peterson]

Try changing the format of that cell to a date.

I get 38679 in cell H1. It should be blank since I have a date in Y1.

 

[roy.okinawa]

No date goes in this cell. Only the cumulative days between today's date and
the date in column W. See the first post.

 

[Max]

Think what was suggested earlier by Gary's Student should work.
Give it another go.

Try in H31, and copy down
: =IF(Y31="",TODAY()-W31,"")

If you want to check for "nothing" in col W as well,
then one way is to put it in H31 as:
=IF(OR(Y31<>"",W31=""),"",TODAY()-W31)
and copy down

 

[roy.okinawa]

Thanks.

The second formula works even better.

 

[Max]

Glad it worked out for you, Roy !