To send direct to me, click on the link below my name and attach your file.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken G" wrote in message
...
Don, I think I know what you are talking about,,but dont know how to send
you
a copy of my sheet so you can see my example

Help

"Don Guillett" wrote:

Show us your layout and an example

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken G" wrote in message
...

Sorry Don,, yes there are blanks in all cells in the row A, except
where
you
do a manual input of the date....because I only have that row to work
with..I
would like it to recognize that date and directly under that date place
the
corresponding day ie: mon, tue, wed ; that date represents..
"Don Guillett" wrote:

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