View original (French)

Formula for date every 7 days in Excel

kekaire78 Posted messages 1 Status Membre -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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