View original (French)

Formula for date every 7 days in Excel

kekaire78 Posted messages 1 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I would like to be able to pull a date cell and have the next date automatically be 7 days later.
For example:
01/02/15
07/02/15
14/02/15

etc.

Can you help me? Thank you.

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    from the 1st to the 7th there are 6 days, not 6!
    With your date in A1
    in A2 just drag down to the usable height:

    =A1+7

    or if you don't want a formula:

    in A1: 1/7/2015
    in A2 8/7/2015
    select A1:A2 and drag down.

    best regards

    --
    To err is human, to persist is diabolical
    0