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
-
Hi,
Are there multiple dates for multiple ships? Are the dates only in 1 row?
Regards
Rainier
-
=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
-
-
This should work for you...
=[Actual Ship Date]@row - [Planned Ship Date]@row
-
=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.
-
If this does not work, try switching the order of the dates...
=NETWORKDAYS([Actual Ship Date]@row, [Planned Ship Date]@row)
Help Article Resources
Categories
Check out the Formula Handbook template!