Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 895
  • Last Modified:

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
0
Neil Russell
Asked:
Neil Russell
1 Solution
 
Rainer JeschorCommented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now