Since everything appears to be working, I'm using =IF([TodayDays]0,0,NETWORKDAYS.INTL(TODAY(),[DueDate],1)), but I have a question. Why The more days left in the calculation, the more days seem to be added on in various date setups.

Since I'm perplexed, I'll pick a start date like 6/16/20 and an end date of 7/16/20, which equals a total of 23 days. However, I only have 25 days remaining after taking weekends into account. How is this even possible?
Nov 14, 2022 in Others 54 views

## 1 answer to this question.

The problem is that you are not counting the days until the start date too in case the start date falls in the future. The formula you are using had been correct all along. I hope this helps you.
• 50,440 points

## Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

## Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

## How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

## Excel Formula: Count cells where value is date

Dates in Excel are just formatted numbers, ...READ MORE

## Excel - count days between two dates per year

Put this in C2 and copy over: =MIN(DATE(C1,12,31),\$B\$2)-MAX(DATE(C ...READ MORE