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

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

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

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

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

On Feb 8, 12:14*pm, Ken G wrote:
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
Here is an example.
http://sites.google.com/site/davesex...attredirects=0
You may have to change your code to start at Row 35

Sub GetDays()
fnl = Cells(65536, 1).End(xlUp).Row
For i = 35 To fnl Step 1
If IsDate(Cells(i, 1)) Then
Cells(i + 1, 1) = Format(Cells(i, 1), "ddd")
End If
Next i

End Sub

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

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")

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")

"feb 2nd" is not a date (at least not to Excel). Tell us exactly what your
entries are ("feb 2nd" like you showed us, a real date with or without
formatting, something else).

--
Rick (MVP - Excel)


"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