Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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