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

7

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

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))

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))

KempenUSA

@prime_nathaniel Much appreciated, That worked.