setting first day of the week

I

Irene

i have a query which is view as pivot table. i have make it to view by
weekly. the user will choose the week as they want to do the report. but now
i have facing a problem that is the first day of the week was setting as
sunday. can i change it to monday? i want my first day of the week is
monday. anybody can help me? thanks!
 
K

Keith Wilby

Irene said:
i have a query which is view as pivot table. i have make it to view by
weekly. the user will choose the week as they want to do the report. but
now
i have facing a problem that is the first day of the week was setting as
sunday. can i change it to monday? i want my first day of the week is
monday. anybody can help me? thanks!
Click to expand...

Hi Irene,

Check out the "Weekday" function in the VBA help.

Regards,
Keith.
www.keithwilby.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Querying the day of the week 2
Start day of week 2
[newbie] first day of week 3
Print calendar with Sunday as the first day of week 3
Week, monthly, quarterly 2
First day of week 1
Pivot table define Monday as first day of week 3
Formula to tell day of week 2

Top