Solved

Excel time differential

Posted on 2012-04-12
181 Views
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
0
Question by:Rayne
• 2

Author Comment

ID: 37841298
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

LVL 17

Assisted Solution

Anuroopsundd earned 200 total points
ID: 37841300
0

LVL 43

Accepted Solution

Saqib Husain, Syed earned 300 total points
ID: 37841305
It should simply be

=A1+C1*7

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

Author Comment

ID: 37841311
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

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Make a Cell act like a Date 7 39
Delete all empty columns using VBA 7 42
Manipulate Range in Excel VBA 6 25
Excel VBA Find Lowest Row number in any selection 8 25
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.