NETWORKINGDAYS

I have the following conditions:

1) Planned Ship Date (9-25-19)

2) Actual Ship Date (9-11-19)

If the Planned Ship Date = Actual Ship Date, Result should = 0

If Actual Ship Date < Planned Ship Date, Result should be a negative number (This should be -10)

If Planned Ship Date>Actual Ship Date, Result should be a positive number

Please advise on the formula

Regards,

Answers

  • @1996mustang

    Hi,

    Are there multiple dates for multiple ships? Are the dates only in 1 row?


    Regards

    Rainier

  • @1996mustang

    =if(Planned Ship Date = Actual Ship Date, 0, if(Planned Ship Date > Actual Ship Date,Planned Ship Date - Actual Ship Date, Actual Ship Date - Planned Ship Date))

    I hope this helps.

    Rainier

  • Yes only one row

  • @1996mustang

    Did the above solution work for you?


    Regards

    Rainier

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    This should work for you...


    =[Actual Ship Date]@row - [Planned Ship Date]@row

    thinkspi.com

  • =IF([Delivery - Planned]# = [Delivery - Actual]#, "0", IF([Delivery - Planned]# > [Delivery - Actual]#, [Delivery - Planned]# - [Delivery - Actual]#, [Delivery - Actual]# - [Delivery - Planned]#))

    This formula did not include NETWORKINGDAYS. The formula did work if the Delivery Actual was less than the Delivery Planned but did work vise versa.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @1996mustang

    If this does not work, try switching the order of the dates...

    =NETWORKDAYS([Actual Ship Date]@row, [Planned Ship Date]@row)

    thinkspi.com