1

In the project I'm working on I have created a column called Project Delivery Start Date and a column called Delivery Days.

I want to use the start date and delivery days to create the Project Delivery Start Date, but need to include the formula

=if([Delivery Days >=6, [Project Start Date]+[Delivery Days]+2, else if(([Delivery Days >=10, [Project Start Date]+[Delivery Days]+4)) 

The reason I want this is if the project has 6 delivery days I need to have 2 extra days to cover the weekend, as these dates will be used to create calendar entries later on

But I keep getting errors

  • I don't get why you wouldn't just make a delivery date column and use that. In any case that your date slips, you specify the new delivery date instead of specifying a new days value. – Eric Alexander May 18 '16 at 11:21
2

What about this to add 4 , 2 or 0 days

=[Project Start Date] + [Delivery Days]
  + IF( [Delivery Days] > 9
        , 4
        , IF( [Delivery Days] > 5
              , 2
              , 0
            )
      )

And if you want to calculate "For Every Week Add 2 days" look into the MOD function

http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List

0

First thing, that catches my eyes is, that you don't seem to close some of the brackets....

=IF( [Delivery Days] >=6
     , [Project Start Date]+[Delivery Days]+2
     , IF( [Delivery Days] >=10
           , [Project Start Date]+[Delivery Days]+4
           , ?????
         )
    )

Also there seems to be a calculation gap where you don't give a value.

Essentially what you showed us is this (this is not real code):

if ([Delivery Days] >= 6)
  [Project Start Date]+[Delivery Days]+2
else
  if ([Delivery Days] >=10) 
    [Project Start Date]+[Delivery Days]+4

But that does not work, your second constraint will never be reached...

  • Sidenote: I mostly write my formulas in Excel and then convert them once they're done. Excel is much more helpfull than SharePoint. – Morten K May 18 '16 at 11:08
  • You can make the SharePoint Calculated Column editor more helpful: github.com/Danny-Engelman/CalcMaster – Danny '365CSI' Engelman May 18 '16 at 11:27
  • Yes there is a ???? gap in the formula, but an else branch is not required as SharePoint will return a FALSE value by default. The 6 and 10 days should indeed be reversed – Danny '365CSI' Engelman May 18 '16 at 11:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.