Microsoft Project Timescale - Week Ending vs Week Starting

[Doc]

Has anyone developed a Week-ending report for Microsoft Project?

Currently all of the timescale "timephased" data are based on
Week-starting. What I am looking for is someone who has developed a
macro, custom report, or mapped the internal data to a spreadsheet to
create a week-ending report. For example the first week in October end
on Saturday:

Sun Mon Tue Wed Thu Fri Sat
25 26 27 28 29 30 1 <-- Week ending Nov 1

Microsoft project Resource Usasge report with a two-tiered timescale
would put this week into the October "bucket" as the week starts Sep
the 25th;

9/25-10/01

Regards
Doc

 

[John]

Has anyone developed a Week-ending report for Microsoft Project?

Currently all of the timescale "timephased" data are based on
Week-starting. What I am looking for is someone who has developed a
macro, custom report, or mapped the internal data to a spreadsheet to
create a week-ending report. For example the first week in October end
on Saturday:

Sun Mon Tue Wed Thu Fri Sat
25 26 27 28 29 30 1 <-- Week ending Nov 1

Microsoft project Resource Usasge report with a two-tiered timescale
would put this week into the October "bucket" as the week starts Sep
the 25th;

9/25-10/01

Regards
Doc

Doc,
I tried playing with various settings and I although it is possible to
have the timescale show a Friday date the data is still for "week
starting".

There are a couple of ways to go. One method is to use the "Analyze
timescale data in Excel" utility and export daily data. Then in Excel,
manipulate the data as desired. A second approach is a custom macro to
export the data as desired. I don't know of such a macro that is readily
available, but it certainly can be written without too much trouble.

How this helps.
John
Project MVP