Excel time differential

Hi

I have a question in excel. Let say there are two date fields. If I enter the [starting] and then enter the time till which something will happen like say 4 weeks, what formula in excel I need to put in the middle cell to add the number of weeks to the starting date and compute the end date ?


starting      Last date      no of weeks for the process
2/1/12             3


Thank you
R
formula.PNG
RayneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RayneAuthor Commented:
Attached the image. So, what i want is that if I add the number of weeks to the start date, then I will be able to get the last date...formula help is greatly appreciated
0
AnuroopsunddCommented:
0
Saqib Husain, SyedEngineerCommented:
It should simply be

=A1+C1*7

where A1 is the starting date and C1 is the number of weeks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RayneAuthor Commented:
Thank you all for your help. Never knew this was that easy...I was thinking maybe I have to change formula and then do further calculation but as you see... The Best solution is the most simplest one :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.