Project Week Number

[aaronrm]

I am looking for a formula or a way to calculate the week number that
a task falls under within a project. I have seen solutions for the
week number within a calendar year.

Ideally I would like to have a column that is the week number start
and a column that this the week number end for each task. I have
placed an example below. Thanks

Task Start End Week
Start Week End
1 3/24/08 3/27/08
1 1
2 3/24/08 3/30/08
1 2

 

[Rod Gill]

Hi,

Try this formula:

Int(([Start]-[Project Start])/7)+1

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com