FORMULATE FOR DAYS

KempenUSA

I want a formula that will capture network days between dates but that will count only if cell has a date entered.

DEPT DATE-1

DEPT DATE-2

RETURN DATE TOTAL TRAVEL DAYS

5/10/2025

5/20/2025

5/30/2025

5/10/2025

5/30/2025

The formula should into the TOTAL TRAVEL DAYS Column and will count days based on following scenarios:

If no Date in DEPT DATE 2 then total Days between DEPT 1 and Return Date

If Date in DEPT DATE 2 then total Days between DEPT 1 and DEPT 2 as value

Find more posts tagged with

Accepted answers

prime_nathaniel

@KempenUSA you want an if then where your if check is whether dept date 2 is blank.

=if(isblank([DEPT DATE-2]@row),NETWORKDAYS([DEPT DATE-1]@row, [RETURN DATE TOTAL TRAVEL DAYS]@row), NETWORKDAYS([DEPT DATE-1]@row, [DEPT DATE-2]@row))

All comments

prime_nathaniel

KempenUSA

@prime_nathaniel Much appreciated, That worked.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.