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.

=IF(Y1="",today()-W1,"") in H
--
Gary''s Student


"roy.okinawa" wrote:

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.

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

"Gary''s Student" wrote:

=IF(Y1="",today()-W1,"") in H
--
Gary''s Student


"roy.okinawa" wrote:

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.

Try changing the format of that cell to a date.

roy.okinawa wrote:

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

"Gary''s Student" wrote:

=IF(Y1="",today()-W1,"") in H
--
Gary''s Student


"roy.okinawa" wrote:

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.

--

Dave Peterson

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

"Dave Peterson" wrote:

Try changing the format of that cell to a date.

roy.okinawa wrote:

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

"Gary''s Student" wrote:

=IF(Y1="",today()-W1,"") in H
--
Gary''s Student


"roy.okinawa" wrote:

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.

--

Dave Peterson

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thanks.

The second formula works even better.

"Max" wrote:

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Glad it worked out for you, Roy !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" wrote in message
...
Thanks.

The second formula works even better.