Template timelines starting at week -12

D

Debbie G

Hi there
I am setting up a template with tasks to use for similar project again and
again.
All of the projects will be based on a 12 week timeline with definate tasks
happening in different weeks. Does anyone know how I can set this up in MS
Project?
I know how to tailor the gantt chart to show weeks but is there anyway I can
set the dates in the task list in weeks and not set dates?
Thanks for any help.
 
G

Gérard Ducouret

Hello Debbie,
Use a custom calculated field such as Text1:
Tools / Custom / Field / Formula:
Us e the DateDiff function with "ww" for weeks as the interval parameter
DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

Hope this helps,

Gérard Ducouret
 
D

Debbie G

Thanks a million Gerard for your advice. I could follow it through to the
formula but cannot see how to enter the 'ww' as the interval parameter. Can
you expand on how to do this bit for me, please?
 
G

Gérard Ducouret

Hi Debbie,

DateDiff("ww", [Date1],[Date2], 1)

interval = "d" for Days, "ww" for weeks....
Replace Date1 and Date2 by any date field.
firstdayofweek = 1 for Sunday; 2 for Monday (optional)

Hope this helps,

Gérard Ducouret
 
S

Steve House [Project MVP]

IF you just use weeks and don't let Project display the actual dates, how
will the guy who is supposed to do the task "Fidget the Widget" know what
day to show up?
 

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