View original (French)

Add weeks to a date

Solved
UsulArrakis Posted messages 7683 Status Contributor -  
UsulArrakis Posted messages 7683 Status Contributor -
Hello,
Excel 2010
I would like to add 6 weeks to a date to obtain the new date.
The YEAR, MONTH, or DAY functions exist in Excel but not WEEK

Does anyone have an idea, preferably with a formula, or otherwise with a macro?

Thank you

Configuration: Win XP pro

(_Usul d'Arrakis
Serial_Dreamer_)

3 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,
    Your date in A1, the number of weeks in B1

    =A1+(B1*7)
    Wednesday 12/6/13 in A1 gives Wednesday 27/7/13

    Best regards

    --
    Michel
    4
  2. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hi,

    this amounts to adding days,
    1 week = 7 days
    6 weeks x 7 days = 42 days

    so date + 42

    or more technically
    =DATE(YEAR(A1);MONTH(A1);DAY(A1)+42)

    except that you haven't mentioned everything and taking into account business days and public holidays
    --
    See you +
    Mike-31

    A period of failure is a perfect time to plant the seeds of knowledge.
    0
  3. UsulArrakis Posted messages 7683 Status Contributor 3 196
     
    Either I'm an idiot or you can tell it's Friday and I'm tired from my work week! :-DDD

    Actually, I just needed D2*7, how foolish of me!!!

    A big thank you to both of you

    I'm mixing your solutions in my file:
    =DATE(YEAR(A2)+B2;MONTH(A2)+C2;DAY(A2)+E2+(D2*7))
    and
    =DATE(YEAR(A2)-B2;MONTH(A2)-C2;DAY(A2)-E2-(D2*7))

    --

    (_Usul from Arrakis
    Serial_Dreamer_)
    0
    1. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
       
      Was my formula too simple?
      0
    2. UsulArrakis Posted messages 7683 Status Contributor 3 196
       
      no no, it's very good
      but I already had the formula with year month day
      so I'm adding a cell where we can enter the number of weeks
      and I adapted my previous formulas by adding D2*7 (which corresponds to your B1*7)

      thanks again and have a nice weekend
      0