Custom Timescale Display in Task Usage

J

Jim Zeeb

Our week-ending day is a Friday and in set in the Calendar defaults.
Our month-end is an Accounting Month which can contain 4 or 5 weeks.

I would like to customize the Timescale display in Task Usage as follows:
Weekly display
1. Display week-ending days (Friday) instead of Week-Starting days
(Saturday)
Monthly display
1. Display Month as user-specified Accounting Month, not Calendar month

I have written a lot of VBA code in MsProject, so if there is a way to do
this in VBA, I would be interested.

InTHANKSAdvance

....jz
 
J

John

Jim Zeeb said:
Our week-ending day is a Friday and in set in the Calendar defaults.
Our month-end is an Accounting Month which can contain 4 or 5 weeks.

I would like to customize the Timescale display in Task Usage as follows:
Weekly display
1. Display week-ending days (Friday) instead of Week-Starting days
(Saturday)
Monthly display
1. Display Month as user-specified Accounting Month, not Calendar month

I have written a lot of VBA code in MsProject, so if there is a way to do
this in VBA, I would be interested.

InTHANKSAdvance

...jz

jz,
Unfortunately Project does not have the capability of directly
displaying accounting month data - at least not in any practical format.
The only way to get there from here is to create a custom VBA macro that
gathers the Project data and then exports it to another application,
such as Excel. I've done it a couple of times for a 4-4-5 sequence and
it works very well but it does take some VBA programming finesse,
particularly to develop the algorithm for the accounting month sequence
over a period of years.

John
Project MVP
 
J

Jim Zeeb

John,

I was pretty sure that was the case, but thought I'd ask.

On the other question, is there a way to show Week-ending date instead of
week-starting date?

....jz
 
J

John

Jim Zeeb said:
John,

I was pretty sure that was the case, but thought I'd ask.

On the other question, is there a way to show Week-ending date instead of
week-starting date?

...jz

Jim,
I don't have Project open at the moment but as I recall it is only set
up to show week-starting. Sorry.

John
 

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

Top