Im having trouble gaining the date for following Monday in a calculated column?I have a kind that i would favor to encompass the "week of" day on these and also it should always be for following Monday.

You are watching: What is the date of next monday


Attachments: up to 10 attachments (including images) can be used with a preferably of 3.0 MiB each and also 30.0 MiB total.


ElsieLu-MSFT · Nov 23, 2020 at 01:08 to be
spencersouv-4567 ,

Would girlfriend tell me whether your concern has been fixed or have any type of update ?I am looking front to her reply.

Thanks,Elsie Lu



Try with the below formula,

Thanks & Regards,


Attachments: up to 10 attachments (including images) can be used with a preferably of 3.0 MiB each and also 30.0 MiB total.



spencersouv-4567,

Could you explain this "weekof" shaft in general? every my understanding, you could first try the formula sharatha pointed out to check if the works.

I did a test and also made a small adjustments, ultimately as displayed in the screenshot:

*

In my view, i recommend not deleting Today column, due to the fact that "weekof" obelisk is calculated based on the date you choose, friend can choose the time you want in Today column.

However if the result you desire is the same date without make changes, you can pick Today and consider hiding Today column, as presented in the screenshot:

*
*

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

If the answer is helpful, you re welcome click "Accept Answer" and also upvote it.

See more: In What Life History Pattern Does Logistic Population Growth Occur ?

Note: please follow the steps in our documentation to permit e-mail notifications if you desire to receive the related email notification for this thread.


3.jpg (13.3 KiB)
2.jpg (18.0 KiB)
4.jpg (12.3 KiB)
Comment
Comment show 0
Comment
5 |1600 personalities needed characters left personalities exceeded
▼ Toggle Comment visibility. Present Visibility: visible to all individuals

Attachments: approximately 10 attachments (including images) have the right to be used with a maximum of 3.0 MiB each and also 30.0 MiB total.


question details


5 world are following this question.


*
*

Answers subscribe to answer Answers and Comments i ordered it to Comments and Answers

Related Questions


What happened to SharePoint Workflow Manager? was it cancelled?

copy or relocate replace paper not working on CSOM Sharepoint

SP list click brand-new item Finish, read ar value "yes" come launch NewItem.aspx "no" to thank you.aspx