Automatic cell entry

[deniseh]

Hi, I have set up a spreadsheet which contains an order date, an expected
delivery date, then a quantity ordered amount. I have set up the order date
to work on a weekly time scale and the delivery date to be the delivery date
plus the expected delivery time, which could be anything from 63 days and
could be altered at any time. This is where I come unstuck I'd like the
next column to be calculated whereby say, the order date was 1st April then
the expected delivery date would be 3rd June 2006 (+63 days), what I wanted
was for the cell which is adjacent to the quantity ordered cell to be filled
automatically by comparing the dates. I have tried if and and, vlookup and
wondered about match, but not too sure about this. Any suggestions would be
gratefully received.
Thanks for your time.
Regards
Denise

[galimi]

What type of compare do you wish to perform? It sounds as if you simply want
to add a fixed number of days to the initial date, in which case, you can
simply add a that whole number to the date, 1 = 1 day in Excel.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"deniseh" wrote:

> Hi, I have set up a spreadsheet which contains an order date, an expected
> delivery date, then a quantity ordered amount. I have set up the order date
> to work on a weekly time scale and the delivery date to be the delivery date
> plus the expected delivery time, which could be anything from 63 days and
> could be altered at any time. This is where I come unstuck I'd like the
> next column to be calculated whereby say, the order date was 1st April then
> the expected delivery date would be 3rd June 2006 (+63 days), what I wanted
> was for the cell which is adjacent to the quantity ordered cell to be filled
> automatically by comparing the dates. I have tried if and and, vlookup and
> wondered about match, but not too sure about this. Any suggestions would be
> gratefully received.
> Thanks for your time.
> Regards
> Denise

[Bearacade]

What exactly would you like the cell adjacent to the quantity order to be filled with?

[deniseh]

i WOULD LIKE THE CELL WHICH CORRESPOINDS WITH THE EXPECTED DELIVERY DATE TO
BE FILLED WITH THE ORDERED QUANTITY. THIS WOULD THEN ALLOW ME TO CALCULATE
THE ACTUAL STOCK LEVELS LESS ANY DRAW DOWNS. IF IT WOULD HELP I COULD SEND
YOU MY SPREADSHEET WHICH EXPLAINS IT BETTER.
THANKS
DENISE

"Bearacade" wrote:

>
> What exactly would you like the cell adjacent to the quantity order to
> be filled with?
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=553679
>
>

[galimi]

Denise,

Feel free to email your spreadsheet to [email protected]
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"deniseh" wrote:

> i WOULD LIKE THE CELL WHICH CORRESPOINDS WITH THE EXPECTED DELIVERY DATE TO
> BE FILLED WITH THE ORDERED QUANTITY. THIS WOULD THEN ALLOW ME TO CALCULATE
> THE ACTUAL STOCK LEVELS LESS ANY DRAW DOWNS. IF IT WOULD HELP I COULD SEND
> YOU MY SPREADSHEET WHICH EXPLAINS IT BETTER.
> THANKS
> DENISE
>
> "Bearacade" wrote:
>
> >
> > What exactly would you like the cell adjacent to the quantity order to
> > be filled with?
> >
> >
> > --
> > Bearacade
> >
> >
> > ------------------------------------------------------------------------
> > Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> > View this thread: http://www.excelforum.com/showthread...hreadid=553679
> >
> >