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.