Date and day formatting

  • Thread starter Thread starter Ken G
  • Start date Start date
K

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
 
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
Click to expand...

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")
 
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..
 
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, 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
 
"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).
 
Back
Top