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
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!