Forum Discussion

tsparkman's avatar
tsparkman
Copper Contributor
May 13, 2021

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" )

 

SharePoint Online
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    May 14, 2021

    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)

      • EmileeNowack727's avatar
        EmileeNowack727
        Copper Contributor
        Aug 22, 2023

        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.

Share

Resources