Sharepoint 2010 calculated column help

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
LVL 37
Neil RussellTechnical Development LeadAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rainer JeschorConnect With a Mentor Commented:
Hi,

please try this one:
=IF(ISBLANK(ReportPeriod),"",TEXT(DATE(YEAR(ReportPeriod),MONTH(ReportPeriod)+1,1),"mm-yyyy"))

Open in new window


HTH
Rainer
0
 
Neil RussellTechnical Development LeadAuthor Commented:
Spot on, saved me the time :P
0
All Courses

From novice to tech pro — start learning today.