SP2013 - How to get the date of next Monday in a calculated column?

Question

Im having trouble getting the date for next Monday in a calculated column?
I have a form that I would like to include the 'week of' date on these and it should always be for next Monday.

Answer 1

Try with the below formula,

=[Today]+(6-MOD(WEEKDAY([Today]),7))+7

Make Sure you create a column Name Today by following below article after you were able to add the formula successfully then go ahead and delete Today column.
https://abstractspaces.wordpress.com/2008/05/19/use-today-and-me-in-calculated-column/

Thanks & Regards,

Answer 2

Hi @Spenser Souvannarath ,

Could you describe this "weekof" column in general? Per my understanding, you could first try the formula sharatha mentioned to test if it works.

I did a test and made a little adjustments, finally as shown in the screenshot:

In my view, I recommend not deleting Today column, because "weekof" column is calculated based on the date you choose, you can choose the time you want in Today column.

However if the result you want is the same date without making changes, you can choose Today and consider hiding Today column, as shown in the screenshot:

Reference:
https://stackoverflow.com/questions/18061089/how-to-calculate-next-monday

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.