Hello, just for a little MORE clarification. what exactly does the begin mean in this formula:
=Begin-(WEEKDAY(Begin,1))+3
i think that if i get that, it will all work for me…do i just copy and paste it in just like this? cause when i do that i get an error. saying that begin insnt the name of a column blah blah. so i make a column named begin, still doesnt work. am i doing something wrong somewhere? am i supposed to replace begin with something else?
Cheers
Chosen Answer:
‘Begin’ is the name of a column in any tasks list. It sounds to me that you are trying out this formula (probably my formula heh), on a list type that is not a task list.
Anyway, if you are trying the formula on a field called ‘Begin’, then use this instead:
=[Begin]-(WEEKDAY([Begin],1))+3
This formula will only work on a date-type field, so when you create the field, make sure it is a date field, like this:
=[Some Date Field]-(WEEKDAY([Some Date Field],1))+3
The name of the field is “Some Date Field”.
Hope that helps!
by: Monkeyman
on: 14th December 07
