I need to put the week numbers against activities. ie act 1 starts on the 2nd June. On the calendar I have set 2nd June as week one. How do I have that next the start date of the activity - same with the finish date.
Act Start Wk No. Finish Wk No.
vvvvvvv 02.06.14 1 20.06.14 3
Regards
Andrew
Agreed - but the week beforehand is -1, not week zero which is what Andrew wants!
Hi Ben
In the date zone properties > Dates & Scales - You set the date at Date zero.
Week 1 follows after that.
Best regards Mike Testro
Hi Andrew,
Off the top of my head - not sure. Will have to look into it. However, I suspect not, as I don't think we have the concept of a Week Zero... How would you define that?!
Cheers,
Ben
Ben
Many thanks for your help, just tried it. It worked to an extent. It works perfectly for weeks 1 to the end of the contract ie positive numbers, but on pre-construction activities the start minus number is correct, but the finish reads -1. Now I know that this is correct as the Friday is still in the -1 week, but is there a way of showing this as a 0 to indicate the end of pre-construction.....
Tricky
Andrew
Hi Andrew,
Add a second Start Date column - it will initially match the column you already have. However, select the whole column and go to the 'Format Cells' option - and chose the option under Date/Time to the second to last option which should result in 'Week' F, 'Day' D.
If you don't want the day of the relevant week showing, next choose custom and delete 'Day' D - leaving only 'Week' F.
I still can't get images to attach to my posts so here is a screenshot in my dropbox: https://dl.dropboxusercontent.com/u/87631006/Week%20Numbering%20Options.JPG
Sorry for the slow reply - been away last few days!
Ben @ Asta
Hi Andrew
If you can write the formula in excell then try the same in the asta spreadsheet.
They are sometimes interchangeable.
Best regards
Mike Testro
Cheers Mike, I thought that might be the case - really easy in Excell !!
Andrew
Hi Andrew
It will need a formula in the cell.
I have no idea what the formula would say and Asta do not make it easy.
Ask Ben Taunt.
Best regards
Mike T.