Calculate End Date Based on Start Date Plus Duration

%3CLINGO-SUB%20id%3D%22lingo-sub-2352812%22%20slang%3D%22en-US%22%3ECalculate%20End%20Date%20Based%20on%20Start%20Date%20Plus%20Duration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2352812%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20hoping%20someone%20can%20help%20me.%20I%20have%20a%20SharePoint%20list%20that%20contains%20three%20columns%3A%3C%2FP%3E%3CP%3EPlannedStart%20%3D%20Date%2FTime%20column%3B%20uses%20Date%20Only%3C%2FP%3E%3CP%3EPlannedEnd%20%3D%20Date%2FTime%20column%3B%20uses%20Date%20Only%3C%2FP%3E%3CP%3EDuration%20%3D%20Number%20field%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20the%20Planned%20End%20field%20as%20a%20calculated%20value%20that%20takes%20the%20Planned%20Start%20Date%20and%20adds%20the%20number%20of%20days%20specified%20in%20the%20Duration%20Field.%20I%20have%20spent%20about%20two%20hours%20researching%20solutions%20posted%20by%20others%20and%20have%20tried%20several%20different%20things%20but%20can't%20seem%20to%20make%20it%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20or%20insight%20is%20greatly%20appreciated!%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3D%5BPlannedStart%5D%2B%5BDuration%5D%0A%0A%3DTEXT(%20%5BPlannedStart%5D%2B%5BDuration%5D%2C%20%22dd%2Fmm%2Fyyyy%22%20)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2352812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2354111%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20End%20Date%20Based%20on%20Start%20Date%20Plus%20Duration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354111%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053366%22%20target%3D%22_blank%22%3E%40tsparkman%3C%2FA%3E%26nbsp%3Byou%20just%20need%20to%20create%20your%20PlannedEnd%20column%20as%20a%20calculated%20column%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22column%20settings.png%22%20style%3D%22width%3A%20597px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280712i6843759F4753254D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22column%20settings.png%22%20alt%3D%22column%20settings.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20the%20result%20is%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22result.png%22%20style%3D%22width%3A%20491px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280713iCDA5EFC09E11AD98%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22result.png%22%20alt%3D%22result.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%2C%20Website%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

2 Replies

@tsparkman you just need to create your PlannedEnd column as a calculated column:

column settings.png

 

Then the result is:
result.png

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

Hi @RobElliott  - Thank you so much for your reply. Your suggestion worked perfectly!