Pivot table define Monday as first day of week

  • Thread starter Thread starter Nick M
  • Start date Start date
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
 
Use The Format Function (Check syntax in help, not before me right now)

HTH

Pieter
 
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
 
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
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
weekday in pivot table 4
Count By week 1
setting first day of the week 1
How do i set the first day of the week to default to Monday? 2

Back
Top