Once again, I thank you. I now have my worksheet the way I needed it and can
go to sleep without it circling my brain. Thanks again, this was a wonderful
resource and one I hope to use again.
Ma2weir

"pinmaster" wrote:

Hi,

You can copy the formulas down by grabbing the small black square in the
bottom right corner of the cell then drag down as far as needed or you can
copy it then paste it into the cells you want. Note that if you need to paste
it into different columns but want to keep the reference to B5 then you will
have to make the reference to B5 absolute by putting a dollar sign ($) in
front of the letter B.

=IF($B5="","",$B5+5)

that way the reference to the column B won't change but the reference to the
row will when dragged down.

HTH
Jean-Guy

"Ma2Weir" wrote:

It worked!! Thank you, thank you, thank you. Now is there a shortcut to
replicate that throughout the sheet for each row? Or do I need to type in
each individually?
Thanks again! This has been driving me bonkers!
Ma2Weir


"pinmaster" wrote:

Hi,

=IF(B5="","",B5+5)
=IF(B5="","",B5+13)

it simply states that if B5 is blank (represented by the double quotes) then
show blank.

Hope this helps!
Jean-Guy

"Ma2Weir" wrote:

Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to
that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you
lay this out in, umm, simple terms? Thanks so much for your help.

"Fred Smith" wrote:

Surround your calculations in an If statement, as in

=if(a1="","",.....)

--
Regards,
Fred


"Ma2Weir" wrote in message
...
I am creating a chart, that adds a varying number of days as you go across
the chart. I have entered formulas to add, and it works fine. EXCEPT...when
there is no starting date entered, all boxes are filled with data. I know it
adds from 01/01/00, but really don't want to see all these nonsensical dates.
I want a clean sheet that data shows up when I enter the baseline cell data.
Any suggestions?