Improve company productivity with a Business Account.Sign Up

x
?
Solved

Sharepoint 2010 calculated column help

Posted on 2013-01-16
2
Medium Priority
?
897 Views
Last Modified: 2013-01-16
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
Comment
Question by:Neil Russell
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 total points
ID: 38782398
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
 
LVL 37

Author Closing Comment

by:Neil Russell
ID: 38782530
Spot on, saved me the time :P
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

These days socially coordinated efforts have turned into a critical requirement for enterprises.
One day, as you try to send an email from your SharePoint account, an error message appears saying: “E-mail Message Cannot be Sent.” You may have outgoing email settings misconfigured.
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question