weekly sharepoint view

[rbc007]

I am attempting to create a new weekly view within SharePoint. However I am having difficulties on showing the view broken down by weeks.

I would like to calculate on a date “completed On” column.

I hoping someone can offer details based on calculation of a column and group by week.


Using:
Formula:
Calculated (calculation based on other columns)

 

[rbc007]

sorry this is a dup, I did not see the posting and reproduced.

thanks

 

[MaxEd]

Try clicking "HELP" from the sharepoint site and look up the functions. That's how I figure out how to write those calculations. Good luck.

-Laughter works miracles.

 

[rbc007]

I have however it is not listed, no help is available

 

[rbc007]

available in the help .... however does not offer details for date calculations or grouping by weekly



Filter items in the view

On the Create View or Edit View page, in the Filter section, click Show items only when the following is true.
If you don't want to filter the list, click Show all items in this view.

In the first drop-down list under Show the items when column, click a column for the first property on which you want to filter.
In the next list, click one of the following operators to apply to this column:
is equal to Includes items with a value that exactly matches the value provided in this filter.
is not equal to Excludes all items matching the provided value.
is greater than Includes all items with a value for the column that comes after the provided value sequentially in a numeric or alphabetical list.
is less than Includes all items with a value for the column that comes before the provided value sequentially in a numeric or alphabetical list.
is greater than or equal to Includes all items with a value for the column that comes after the provided value sequentially in a numeric or alphabetical list, and any items that match the provided value.
is less than or equal to Includes all items with a value for the column that comes before the provided value sequentially in a numeric or alphabetical list, and any items that match the provided value.
begins with Includes all items that begin with the provided characters.
contains Includes all items that contain the provided characters in the order provided.
In the next box, type a value you want to compare to entries in the column you are filtering on.
Different columns accept different values. For example, the Created column only accepts values formatted as dates, and other columns might be limited to numbers, letters, or other combinations of characters.

Note You can use two special values to specify the current date or the current user. You can use [Today] to filters on a column that contains dates for the current date. You can use [Me] to filter on a column that contains user names for the current user of the view.

In the lists under When column, select a column, operator, and value for a second filter rule.
Select And to include items that match both filter rules, or Or to include items that match either of the filters.
For example, to display to each team member only those items that he or she created, click Created By in the first list, click is equal to in the second list, and then type [Me] in the box. This creates the statement "Show the items when column Created By is equal to [Me]." Only items created by a user are displayed to that user.

At the bottom of the page, click OK.

 

[rbc007]

STILL HOPING FOR HELP.... it is still outstanding



thanks for reading