NETWORKINGDAYS

1996mustang

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,

Find more posts tagged with

Accepted answers

All comments

Rainier Hollands

@1996mustang

Hi,

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

Regards

Rainier

Rainier Hollands

@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

1996mustang

Yes only one row

Rainier Hollands

@1996mustang

Did the above solution work for you?

Regards

Rainier

Paul Newcome

This should work for you...

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

1996mustang

=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

@1996mustang

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.