formula

[steve]

hi i am trying to create a formula that will give me a one week period.
example Saturday through Friday. so if i into say 07/18/2008 in the cell that
Friday is located i wish to see 07/25/2008.
please understand i am a NOOB at Excel.

 

[Pete_UK]

If you enter a Friday date in A1, say, then put this in B1:

=A1+6

which will give you the following Saturday's date. If you just want
multiple dates that are a week apart, put this in A2:

=A1+7

and copy down. You can also copy B1 down.

Hope this helps.

Pete