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?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
It should simply be

=A1+C1*7

where A1 is the starting date and C1 is the number of weeks
0
 
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
 
AnuroopsunddConnect With a Mentor Commented:
0
 
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
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.

All Courses

From novice to tech pro — start learning today.