VB Code to insert formula for Day of the week.

[rizmomin]

HELLO:

Please refer to attached file.
i have date in column A starting from A2.

I need a VB code to display the day for date in column A.
For example :
F2 = TEXT(A2,"Ddd")
F3 = Text(A3,"Ddd") and so on.

Let me know if you have any questions.
Thanks.

Riz

[GC Excel]

Maybe something like this ?
(just adapt as required)

Please Login or Register  to view this content.

[rizmomin]

Hi GC Excel:

Thanks a lot, works great.
Riz

[Norie]

Or this.
[code]
With Range("F2", Range("A" & Rows.Count).End(xlUp).Offset(,5))
.Formula = "=TEXT(A2, ""ddd"")"
.Value = .Value
End With
[code]