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
--
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.

[roy.okinawa]

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]

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

[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.

"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
>

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

[roy.okinawa]

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
> --
>
>
>

[Max]

Glad it worked out for you, Roy !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"roy.okinawa" <[email protected]> wrote in message
news:[email protected]...
> Thanks.
>
> The second formula works even better.