Removing a date by inputting a newer one in another cell

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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
 
Eduardo said:
Hi,
could you please provide with and example of the layout of your
spreadsheet,
thanks
Click to expand...

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

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
 
Eduardo said:
Hi,
could you please provide with and example of the layout of your
spreadsheet,
thanks
Click to expand...

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