in SharePoint 2010 I have the following columns Date Scheduled and Frequency. I have a work order currently scheduled for 9/1/2015 and a Frequency of 1. The frequency column is based on weeks. So with a freq of 1 the next work order would be due 9/8/2015. Frequencies go from 1-52. What formula in SharePoint 2010 can I use to get me that next due date?


Create a calculated column and use =[DateScheduled]+(Frequency*7). Return as Date and time.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.