Issue with VBA.Format(Today(), "dddd d, mmmm yyyy \Dw\Www\Qq")

[Juggler_IN]

The statement

VBA.Format(Today(), "dddd d, mmmm yyyy \Dw\Www\Qq")

gives the day count of the week assuming Sunday is day 1 of the week. So, today (7th August) is D6. How do I get D=5 (i.e. assuming week starts from a Monday)?

 

[jasonb75]

You can use 'weekday' for that.

Formula =WEEKDAY(TODAY(),11)

Weekday(Date,vbMonday)

 

[Juggler_IN]

@jason75; Weekday with 11 doesnt work with VBA 2003.

 

[Fluff]

Please update your account details to show which version of Excel you use. That way members don't waste their time offering a solution that doesn't work.

 

[MARK858]

@jason75; Weekday with 11 doesnt work with VBA 2003.

jasonb75 supplied a formula and VBA option in post #2. Did you try the VBA option?
Make sure that you don't miss post #4

 

[Juggler_IN]

Please update your account details to show which version of Excel you use. That way members don't waste their time offering a solution that doesn't work.

The platform page does not provide 2003 as an option. Lowest is 2007. How do i do it? 2003 as version?

 

[Peter_SSs]

The platform page does not provide 2003 as an option. Lowest is 2007.

In that case whenever you start a thread you should state clearly in the first post that you are using Excel 2003. One problem is that most helpers will not remember too well exactly what is and is not available in that version. (Probably nearly time to upgrade. )