Re: How to change (delivery) days and automatically the receive date in an other cell?

From: Elboo (Elboo.1g4ihz_at_excelforum-nospam.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 06:51:42 -0600

Ok thanks, that's something that looks good. But the only thing is that
de order date is given (in my case when there are more then 21.600 subs
used).

But i will try to fix it, if you have a suggestion i will hear it.

Thanx 4 your time :)

With many love ;) Mark

> Hi Elboo
>
> To get what i think you're after to work i had to change it just a
> little ..
> ..................column A..........column B
> row 1.......Order No..........ABC123
> 2................Order Date........5/1/05 (ie 5 Jan 05)
> 3................Del. Time (days)..3
> 4...............1/1/05..................=IF($A4=B$2,"order
> date",IF($A4>B$2,IF(B$2+B$3=$A4,"delivery",""),""))
>
> and filled down the column
> Now you enter the order date in B2
> enter the number of days delivery in B3
> and on your calendar you will see the words "order date" and
> "delivery"
>
> If you change either B2 or B3 the calendar will adjust automatically
> You can then go across into column C for the next order etc ...
>
> Hope this helps.
> Cheers
> JulieD
> 

-- 
Elboo
------------------------------------------------------------------------
Elboo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16624
View this thread: http://www.excelforum.com/showthread.php?threadid=318689