VBA Code for Date and Day of Month

[rizmomin]

Hello:

Could some one tell me VBA Code to insert Day,Date in A1,A2 and A3 as follows:

A1 = Day# of Today's date eg 5/7/2007 ....A1=7
A2 = Todays Date ................5/7/2007
A3 = TEXT(A2,"ddd") = Mon

7 5/7/2007 Mon

Thank U....

Riz Momin

[Leith Ross]

Hello Riz,

Please Login or Register  to view this content.

Sincerly,
Leith Ross

[rizmomin]

Hi Leith:

Adding above Code ...gives Compiled Error: Sub or Function not defined...

Please help

Riz Momin

[rizmomin]

i got it fixed with following code....

Cells(85, 14).Value = Date
Cells(85, 13).Value = Format(Cells(85, 14).Value, "d")
Cells(85, 15).Value = Format(Cells(85, 14).Value, "ddd")

Once again many thanks to all ....

Riz Momin