How can we calculate ([Due Date]- [Today])/7 column that updates daily as value of Today changes and lets us calculate weeks left for due date ? Could create ([Due Date]- Today() )/7 and it worked fine but it value of Today() in this is not dyanmic and changes only when we edit an existing entry or create a new one . Any ideas as how to achieve display of weeks left for due date dynamically ?
Did you google "dynamic value of today sharepoint" ? You can see that this topic has been discussed again and again, in MOSS and SP2010.
There is a workflow with loop "solution" : https://sites.google.com/site/sharepointhill/tutorials/mssp/sp-dynamic-today-date
Or you may want to add some custom code or timer jobs that update each element of the targeted list every X minutes ....
Good Luck !
I wrote an article a while back about the different methods for creating a CountDown on a list view, which is essentially what you're looking for:
Warning: This also mentions our own product as a possible solution
Here is a summary of the options:
More specifically, I also wrote a (similarly product plugging) article on using [Today] in a list view:
This article gives more background on why [Today] doesn't work:
It also received the following rave review from the venerable Mike Walsh himself: