+ Reply to Thread
Results 1 to 6 of 6

Give End Date Based on Start Date & Weekes Needed

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Thumbs up Give End Date Based on Start Date & Weekes Needed

    Hi

    In cell A3, I have a start date of: 12/08/14

    In cell A4, I have an estimated number which represented the estimated weeks needed

    I'm looking for a formula that can provide the end date based estimated weeks given.

    Thanks
    Last edited by mycon73; 12-07-2014 at 11:46 PM.
    MyCon
    -- Using Latest Version of Excel

  2. #2
    Forum Contributor
    Join Date
    10-04-2014
    Location
    Europe
    MS-Off Ver
    2007
    Posts
    107

    Re: Give End Date Based on Start Date & Weekes Needed

    Hi
    Will this work =A3+(A4*7)

    Regards.

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Give End Date Based on Start Date & Weekes Needed

    Try this...

    =A3+(A4*7)

    Format as Date
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Re: Give End Date Based on Start Date & Weekes Needed

    Hi Bobsone & Tony Valko,

    I figured it would be something simple. I must be tired & kind of brainless at the moment.

    Both examples given work great!!!

    Thanks

  5. #5
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Re: Give End Date Based on Start Date & Weekes Needed

    Hi Bobsone & Tony Valko & Others,

    Now that I see this "simple" answer, how can this be modified to show a Week Ending Friday or Sunday's date?

    This function in another cell works well for getting a week ending Sunday & I'm thinking I want a variation with this to be combined with your suggested example.
    =A4-WEEKDAY(A4,2)+7


    Thanks

  6. #6
    Forum Contributor
    Join Date
    10-04-2014
    Location
    Europe
    MS-Off Ver
    2007
    Posts
    107

    Re: Give End Date Based on Start Date & Weekes Needed

    Hi
    I have loaded a simple sheet, is it what you are looking for?

    Regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-31-2014, 01:38 AM
  2. Calculate next due date based on start date frequency and current date
    By ironoverload in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-09-2014, 07:08 AM
  3. Replies: 0
    Last Post: 07-03-2012, 03:52 PM
  4. Replies: 4
    Last Post: 06-02-2012, 11:26 AM
  5. Replies: 1
    Last Post: 03-31-2011, 05:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1