I have a table full of dates. The raw data in the cells consists of dates in
mm/dd/yyyy format. The visual data, modified by formatting the cells (right
click, format cells, date), is: ddd mm/dd/yy.

The first three characters in the formatting are the day of the week (Mon,
Tue, Wed, etc.) I want to reference that data (the ddd) and assign a number
to it.

Ex. Mon=500, Tue=350, Wed=10,000

Is there any way to reference something that is not hard data in a cell to
return a value in another cell. I can't seem to "grab" that data to return
my value.

All help is greatly appreciated! Thanks!