Help With Counting Days for Tracking Network Days & Exact

0

Hello,  I'm looking for two things which I found reference to online but can't formulate properly. #1. The total Network days in column (D) which will be from the start_date (A) to accepted offer date (B) with an answer to appear in column D even if the other columns are not filled in with dates. The formula I have entered currently inputs the total days until a date is input into column B and then the Network Days are calculated.  #2.  I would like the total days to appear in column (E) from (A) to (C) and would like (C) to be referenced as todays date without it actually showing until a date has been entered. I have tried different =IF or =DatedIF formulas and I do not want to add a column indicating a current date with today() or Now,  if I do not need to. I've attached an example. PLEASE assist.

Answer
Discuss

Answers

0

It looks like you have the correct formula in column D.

For column E it looks like this formula, that you have in one of the cells, should work:

=IF(C5="",(TODAY()-C5),NETWORKDAYS.INTL(A5,C5))
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login