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
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