formula
 

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.
--
"It were better to be a soldier´s widow than a coward´s wife"
"The onset of bayonets in the hands of the valiant is irresistible"
"Veni, vidi, vici"
(I came, I saw, I conquered)

formula
 

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

On Jul 21, 12:25*pm, steve wrote:
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.
--
"It were better to be a soldier´s widow than a coward´s wife"
"The onset of bayonets in the hands of the valiant is irresistible"
"Veni, vidi, vici"
(I came, I saw, I conquered)