Show us your layout and an example. Are there blanks?, etc.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken G" wrote in message
...
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