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

Need some PWA help 0
How to implement two shifts per day with multiple teams 0
Task Information Dialog Box not making duration changes to task 0
Resource name inside resource sheet: per person, work per hours per week 0
Office 365 Calender 0
Show week number in Project Report 0
Report Group Footer DLookUp 0
Found few bugs in my daily routine of work in excel for MAC 0

Top