Changing a day and date

[ttus]

I have a spreadsheet, which has days and dates. These are Not one after the other , They are every eight lines apart. How do I change this to be date that are day to day, (sat and etc) and number as this ( 7/15/11)

Tried most of My understanding, hasn't worked yet

Thanks

 

[VoG]

Select the date column, press F5, click Special, click Blanks and click OK.

Press =

Press Up arrow

type +1

hold down CTRL and press Enter

 

[ttus]

The dates and day are in the same coulun with the wording

Sure wish there was a way to show you how it is.

Is it possible to email it to you?

Thanks

 

[VoG]

Try putting borders around the cells then copy and paste here.

 

[ttus]

dates need to change one day only like 714/11 and eight rows down, it needs to cange to

7/15/11 then and eight rows and change to 7/16/11 and so on. These are in the same

Coloum with other things.

Thabnks

 

[Greg Truby]

Assuming your start date is in A1, the following formula in A2 and copied down would do the trick (cells would need to be formatted as dates).

• =IF(NOT(MOD(ROW()-ROW($A$1),8)),OFFSET(A2,-8,0)+1,"")


If you want to go ahead and start the eight rows down and then copy down, you can nix the OFFSET and just use a reference, i.e. A2:A8 are empty and A9 is:

• =IF(NOT(MOD(ROW()-ROW($A$1),8)),A1+1,"")

 

[ttus]

Ok Greg I will try that, sure thank you for your time and help.

Bill