Solved: Todays Date Name in VBA

[JimS]

How can I convert the following formula so that I can use it in VBA (or use some other method)?

=TEXT(TODAY(),"ddd")

Basically I have a several IF/Then VBA Statements and depending on what todays day name is (ie: Mon, Tue, Wed, Thu or Fri) will determine which If/Then Statement gets executed.


Thanks...

Jim

[Kenneth Hobs]

MsgBox Format(Date,"ddd")

[Bob Phillips]

If Format(Date,"ddd") = "Mon" Then

[JimS]

Thanks xld, perfect...