Service Interval Calculator

Hello,

I'm trying to create a Service Interval Calculator but in all honesty I have no idea where to begin. I reviewed some examples from various sites but can't seem to get the concept....

I have included an example of what I was given to work with ...

Any help is appreciated and thank you advance,

Arv

I have included an example of what I was given to work with

It's no wonder you're having a problem, you were given pictures instead of a spreadsheet with data that can be manipulated.

Please post an example of a working spreadsheet instead of pictures. Please include a description of what you are trying to achieve. Before and after data would also be useful. Get rid of the Email fields as well.

LOL ...

thats the issue my friend..... the only thing i have as a reference are those pictures .....

What I want to achieve is .... the service rep to enter the date (day and time) the order was received and have excel determine the due dates.

Still need more info...
Can you give some examples?
The rep enters 2/2/2010 (a Tuesday) at 16:00 - what is the output?

As far a being given pictures - You Got (insert you favorite term)!

As far a being given pictures - You Got (insert you favorite term)!

LMAO! ... thats what I thought too

The rep enters 2/2/2010 (a Tuesday) at 16:00 - what is the output?

The output be .... Confirmation to be sent by 2/3/2010 12:00pm Wednesday with a Due Date 2/4/2010

Based on "Block 3" from the beautiful pictures

I think I'm on to something .....

http://www.cpearson.com/excel/DateIntervals.htm