I would like for it the automatically recognize a date in that row...then
directly under that date., type in the day of the week that date corelates to

"CurlyDave" wrote:

On Feb 8, 9:05 am, Ken G wrote:
I am having a prblem trying to create a date..day..formula
I have a date posted in row A say feb 2nd
from rows 36 to1000 ($A$35:$A$1000)
I want it to look in those cells and look for a date..
then in the cell directly under neath the date..place a mon, tues , wed
..etc..respective of that date..
I believe it can be done in VB..but I know nothing of that type of
programming..and where would I put that formula to get it to do that

I assume you mean next to the cell, not underneath the cell.
Can you just use a formula next to the date?
=A35
then custom format the range ddd
or use
=text(a35,"ddd")