[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

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
0
Rayne
Asked:
Rayne
  • 2
2 Solutions
 
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
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now