Help: Auto generation of ID number, delivery date

A

ashokdc

Dear friends,
I would appreciate if you kindly help me to prepare an excel sheet
with Auto generation of ID number, delivery date , once I select
customer name and enter receive date.

In sheet 2: I have already entered the customer name, ID no and
delivery timeline.
In sheet 1: If I select “Name of the customer” from dropdown and enter
the “Receive date”

I want three fields to be populated automatically: ID no, Delivery
date and time remaining from today.

To calculate days remaining from today, I used
=IF(D4>TODAY(),D4-TODAY(),"")

I need help to generate Customer ID and delivery date.

Thanks in advance for your help.

.......................................................................................................................................................................................
Name of the customer ID no. Receive date Delivery date Time remaing
from today
A 26-Feb-2011
...........................................................................................................................................................................
Name of the customer ID no. Delivery timeline
A 1XX 45 Working days
B 2YY 33 calendar days
C 3ZZ 2months
D 4MM 2 years
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delay delivery 0
Converting excel to PDF, single page converts to multiple HELP! 1
How to generate list of items with same status over three or moresuccessive days 3
=IF function with current date 3
Delivery lead time formulas 1
Query Design - Display data depending on date 1
DATA IN SHEET 1 ON THE BASE OF SHEET 2 1
Incessant Delivery Status Notificiations 0

Top