Forum Discussion
tsparkman
May 13, 2021Copper Contributor
Calculate End Date Based on Start Date Plus Duration
Hi All -
I'm hoping someone can help me. I have a SharePoint list that contains three columns:
PlannedStart = Date/Time column; uses Date Only
PlannedEnd = Date/Time column; uses Date Only
Duration = Number field
I am trying to set the Planned End field as a calculated value that takes the Planned Start Date and adds the number of days specified in the Duration Field. I have spent about two hours researching solutions posted by others and have tried several different things but can't seem to make it work.
Any help or insight is greatly appreciated!
=[PlannedStart]+[Duration]
=TEXT( [PlannedStart]+[Duration], "dd/mm/yyyy" )
- RobElliottSilver Contributor
tsparkman you just need to create your PlannedEnd column as a calculated column:
Then the result is:
Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)- tsparkmanCopper Contributor
Hi RobElliott - Thank you so much for your reply. Your suggestion worked perfectly!
- EmileeNowack727Copper Contributor
RobElliott I know this post is old but I would like to ask if there is a way to do this same thing but the Duration is calculated by hours instead of days? Thanks for any feedback you may have.