<div>
Spot on, saved me the time :P
</div>


<div>
<div class="content wysiwyg-content">
OK, I have somebody just come ask me if I can add a calculated column to do the following to one of their sharepoint 2010 lists....<br />
<br />
Existing column called ReportPeriod, Single line of Text, input mask of &quot;\d\d\-\d\d\d\d&quot;<br />
<br />
So field always contains something like &quot;02-2013&quot;<br />
<br />
They would like a single calculated field adding that will display the NEXTreportingPeriod, based on 12 periods per calendar year.<br />
<br />
So in the above example, the NextReportingPeriod will be &quot;03-2013&quot;<br />
<br />
Must handle &quot;12-2013&quot; giving &quot;01-2014&quot;<br />
<br />
Anybody give a single formula for this?<br />
<br />
Thanks in advance, i hope,<br />
<br />
Neilsr
</div>
</div>


OK, I have somebody just come ask me if I can add a calculated column to do the following to one of their sharepoint 2010 lists....

Existing column called ReportPeriod, Single line of Text, input mask of "\d\d\-\d\d\d\d"

So field always contains something like "02-2013"

They would like a single calculated field adding that will display the NEXTreportingPeriod, based on 12 periods per calendar year.

So in the above example, the NextReportingPeriod will be "03-2013"

Must handle "12-2013" giving "01-2014"

Anybody give a single formula for this?

Thanks in advance, i hope,

Neilsr

Sharepoint 2010 calculated column help

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.