Removing a date by inputting a newer one in another cell
 

I have office excel 2007. I am a fairly new user,
I have a worksheet which maintains and monitors the movement of various
units, and is controlled by quantity and dates.
What I would like to do is write a formula that will remove the ordered date
when I input the new start date, which would be the newer date. So far I
have not been able to make this work.
I would appreciate any help or advice you can give me.

Many Thanks
Mike

Removing a date by inputting a newer one in another cell
 

You could use a worksheet_change event that clearscontents of the original
cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike" wrote in message
...
I have office excel 2007. I am a fairly new user,
I have a worksheet which maintains and monitors the movement of various
units, and is controlled by quantity and dates.
What I would like to do is write a formula that will remove the ordered
date when I input the new start date, which would be the newer date. So
far I have not been able to make this work.
I would appreciate any help or advice you can give me.

Many Thanks
Mike

Removing a date by inputting a newer one in another cell
 

Hi,
could you please provide with and example of the layout of your spreadsheet,
thanks

"Mike" wrote:

I have office excel 2007. I am a fairly new user,
I have a worksheet which maintains and monitors the movement of various
units, and is controlled by quantity and dates.
What I would like to do is write a formula that will remove the ordered date
when I input the new start date, which would be the newer date. So far I
have not been able to make this work.
I would appreciate any help or advice you can give me.

Many Thanks
Mike

Removing a date by inputting a newer one in another cell
 

"Eduardo" wrote in message
...
Hi,
could you please provide with and example of the layout of your
spreadsheet,
thanks

Hi.

Item ! Start Date ! Qty ! Reorder Date ! Warning 7 Days ! Status ! Date
Ordered ! ! 13/07/09 ! 24 ! ! ! reorder! 06/07/09 !

When a new start date is input the other dates recalculate and the status
column changes to okay. The date ordered does not change, this the date I
would like to remove, just to save a few less clicks on the sheet, and so I
don't forget to delete it.
Hope this makes sense.

Mike


"Mike" wrote:

I have office excel 2007. I am a fairly new user,
I have a worksheet which maintains and monitors the movement of various
units, and is controlled by quantity and dates.
What I would like to do is write a formula that will remove the ordered
date
when I input the new start date, which would be the newer date. So far I
have not been able to make this work.
I would appreciate any help or advice you can give me.

Many Thanks
Mike



Item ! Start Date ! Qty ! Reorder Date ! Warning 7 Days ! Status ! Date
Ordered ! ! 13/07/09 ! 24 ! ! ! reorder! 06/07/09 !

When a new start date is input the other dates recalculate and the status
column changes to okay. The date ordered does not change, this the date I
would like to remove, just to save a few less clicks on the sheet, and so I
don't forget to delete it.
Hope this makes sense.

Mike

Removing a date by inputting a newer one in another cell
 

"Eduardo" wrote in message
...
Hi,
could you please provide with and example of the layout of your
spreadsheet,
thanks

Hi,
Will try.

Item ! Start Date ! Qty ! Reorder Date ! Status ! Date Ordered !
! 13/07/09 ! 24 ! ! reorder! 06/05/09 !
not all columns are shown that are in the work sheet, just some indication of the layout

When the date in B2 is greater than the date in F2 then delete/remove the date in F2
When a new start date is input the other dates recalculate and the status
column changes to okay. The date ordered does not change, the date. I
would like to remove, just to save a few clicks on the sheet, and so I
don't forget to delete it.
Hope this makes sense.

Mike






"Mike" wrote:

I have office excel 2007. I am a fairly new user,
I have a worksheet which maintains and monitors the movement of various
units, and is controlled by quantity and dates.
What I would like to do is write a formula that will remove the ordered
date
when I input the new start date, which would be the newer date. So far I
have not been able to make this work.
I would appreciate any help or advice you can give me.

Many Thanks
Mike