Hello,I am a newby and a civilian (by that I mean not IT) and I have a question regarding a calculated column that i have extensivly used in a number of lists.

I needed a column which displayed the "created" calander week and year for each item in the list and I after researched on the internet came up with;

=INT((Created-DATE(YEAR(Created),1,1)+(TEXT((WEEKDAY(DATE(YEAR(Created),1,1),2)),"d")))/7)+1&"/"&TEXT(Created,"yy")

The output is for example 32/15.

This formula has worked for months but twice now on different lists it has decided no to work consistently so that for the last few days it has been returning;

-99085/99

If I open the column list settings and just save it again without changing the formula all the entries which are incorrect are corrected, but then new entries are created again with the -99085/99 value.

I have come to the end of my abilities with SharePoint and would greatly appreciate any ideas you may have as to how to solve this issue.

Thanks,

Marco

Hi Bearsparko,

Try adding [] around the Created field. Also for troubleshooting, try displaying the created alone in another calculated field.

Another point is to makesure you have selected single line of text as the field type.

Regards,

Rajesh

http://sharepointr.blogspot.sg

• Proposed as answer by Ganesan Rajesh Kumar 12 hours 8 minutes ago
• Edited by Ganesan Rajesh Kumar 12 hours 7 minutes ago

Hi

check this link

http://kishansharepoint.blogspot.ro/2012/05/common-datetime-formulas-for-sharepoint.html

Hi Bearsparko,

Try adding [] around the Created field. Also for troubleshooting, try displaying the created alone in another calculated field.

Another point is to makesure you have selected single line of text as the field type.

Regards,

Rajesh

http://sharepointr.blogspot.sg

• Proposed as answer by Ganesan Rajesh Kumar Friday, July 24, 2015 7:34 PM
• Edited by Ganesan Rajesh Kumar Friday, July 24, 2015 7:34 PM