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
Member for
17 years 4 months
Member for17 years4 months
Submitted by Andrew Owenson on Wed, 2014-06-11 17:56
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.....
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.
Member for
13 years 9 monthsAgreed - but the week
Agreed - but the week beforehand is -1, not week zero which is what Andrew wants!
Member for
19 years 10 monthsHi BenIn the date zone
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
Member for
13 years 9 monthsHi Andrew,Off the top of my
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
Member for
17 years 4 monthsBen Many thanks for your
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
Member for
13 years 9 monthsHi Andrew,Add a second Start
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
Member for
19 years 10 monthsHi AndrewIf you can write the
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
Member for
17 years 4 monthsCheers Mike, I thought that
Cheers Mike, I thought that might be the case - really easy in Excell !!
Andrew
Member for
19 years 10 monthsHi AndrewIt will need a
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.