Column D = Date closed (1/1/2009 format)
Column AF = Day Closed (custom "d" format)
Column AG = Week Closed (General Format)

Column AF gets the day closed using the formula:
=D2
Column AG gets the Week Closed using the formula:
=IF(OR($AF2=1,$AF2=2,$AF2=3,$AF2=4,$AF2=5,$AF2=6,$ AF2=7),"Week One,""))

The formula works in Column AF, but I can't the formula to work in Column
AG.
It leaves the cells blank.
I thought maybe the formula in AF is interfering with the formula in AG.
So I took the fomula out of AF and put the same value in the cell. Presto.
The formula in AG worked.

Is there a solution to this? Why can't the formula read the value from the
cell unless I make it a "Number" format?

Maybe I am doing everything wrong. Any help would be appreciated.