Date and day formatting

[Ken G]

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 Guillett]

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

 

[CurlyDave]

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

 

[Ken G]

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..

 

[Ken G]

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

 

[Don Guillett]

Show us your layout and an example

 

[Ken G]

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

 

[Rick Rothstein]

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

 

[CurlyDave]

Don, I think I know what you are talking about,,but dont know how to sendyou
a copy of my sheet so you can see my example

Help

Here is an example.
http://sites.google.com/site/davesexcel/Home/forum-examples/PlaceDaysUnderDate.xls?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

 

[Don Guillett]

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