416-621-9348 cgreaves@chrisgreaves.com
Home Services Products

Formulae and Formatting

Your spreadsheet holds a column of dates and a column of weights. ("Dates and Weights"!).

We would like to see the day-of-the-week between the two columns.

In the cell at the top of the empty column, key in another formula. This time we want to obtain a formula for the value in the cell immediately to the left.

Tap the Equals key, the Left-Arrow key, then tap the Enter key.

You can read this any way you want; I think of it as "I want what is equal to that there"

Now let's format the new formula to make it show us the day of the week.

With the new formula cell selected, from the menu system choose Format, cells (Alt-O, E).

In the left-hand pane choose "Custom" and in the text box of the right-hand pane type "DDDD" (without the quotes.

Then tap the Enter key to confirm out of there.

Finally, use the Fill-Down technique to propagate this newly formatted formula down to the last row of your data.

CGreaves@ChrisGreaves.com

Loading

Toronto and Mississauga, Sunday, December 05, 2010 3:17 PM

Copyright © 1996-2010 Chris Greaves. All Rights Reserved.