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