Converting dates

[OllyJ]

Hi guys

I have a report which auto groups my daily results into weeks by week number:

=Format$([OrderDate],"ww",0,0)

...Any ideas how I can introduce a column that would state 'Week Commencing Date' for each week???

Thanks in advance, OllyJ

[MikeTheBike]

Hi guys

I have a report which auto groups my daily results into weeks by week number:

=Format$([OrderDate],"ww",0,0)

...Any ideas how I can introduce a column that would state 'Week Commencing Date' for each week???

Thanks in advance, OllyJ

Hi

Something like this

Dim YourDate As Date
    YourDate = Date
    
    MsgBox "Week Commencing Monday " & YourDate - (Weekday(YourDate, vbMonday) - 1)

If you want week commencing on any other day just change vbMonday constant to suit.

??


MTB