Pivot table define Monday as first day of week

N

Nick M

Hello,
I have a pivot table "form" I created using the pivot table wizard.
The table it is pivoting on has InstDate (install date) and SerNo date
format is mm/dd/yyy
I have the pivot table counting SerNo fields and that is grouped by year
then week.
I noticed that Sunday is the first day of the week.
How do I change that to Monday so the full week is Mon - Sun?
If I run queries using date part it to uses Sun as the first day.
I don't know vb, but I'll try anything to get this "report" to show my
totals correctly.
Regards
-N
 
P

Pieter Wijnen

Use The Format Function (Check syntax in help, not before me right now)

HTH

Pieter
 
N

Nick M

Format in the help area show how to format the date column, but does not
show how to define Monday as the first day of the week.
Regards
-N
 
P

Pieter Wijnen

Format(Date(),"ww",2)

Pieter

Nick M said:
Format in the help area show how to format the date column, but does not
show how to define Monday as the first day of the week.
Regards
-N
Click to expand...
 

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

How & Where to change the week Starting day. 3
Define Mon as first day of the week. 4
Count By week 1
setting first day of the week 1
Day of the week 3
Calculate day of week in form & store in table 2
How can I set the first day of week to Monday in a pivotchart? 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0

Top