Formula to fill cell in with the day of the week

[suprsnipes]

I have a sheet with the following data in column A beginning from row 2.

Mon
blank
blank
blank
blank
blank
Tue
blank
blank
Wed
blank
blank
blank
blank
Thu
blank
blank
Fri
blank
blank
blank
Sat
blank

What I want to do is fill in the blank cells with the same day as the bold day above it using a formula that allows for the days and blanks to be in different rows as the above data is linked to another sheet.

How could I achieve the above?

Thank you in advance,
suprsnipes

 

[Jonmo1]

Hilghlight the column
Click Edit - Goto - Special - Blanks - OK.
Press =
Press UP Arrow
Press CTRL + ENTER


Hope that helps.

 

[anglais428]

To fill as the same as the bold cells, highlight the cells, CTRL + click on A2, CTRL G, special, highlight blanks, enter "=" and press the up arrow key, click CTRL + Enter

 

[suprsnipes]

I actually want to fill the blank cells in using a formula. The blank cells contain a basic formula already that references the same cell id on another sheet so perhaps what I need is a formula that can be placed in column B that can fill in the blanks?

I am using Excel 2000.

 

[Jonmo1]

I actually want to fill the blank cells in using a formula.

I am using Excel 2000.

The suggestions ARE formulas.