Kamelozlr

 Formula For Date Minus Date = Number Of Days I was wondering if anyone knows how I could enter a date in one cell, then another date in a second cell and in a third cell have it have it so it minuses the first date from the second and calculates the difference outputted in number of days Add / subtract days to date If you have a list of date in a range or worksheet, and you want to add or subtract a certain number of days to the date in the range, you can refer to the following general formula =Date days Or =Date days For example, to add 100 days to a date in Cell B1, then you can write the following formula in Cell C1 Then format the data like a number, like so Pretty straightforward The first project has 29 days total and the second project has 7 days Also, if you're wondering why the formula produced dates of and 1/7/1900, click here Now let's get the business days with the NETWORKDAYS() function We're going to include the Holidays list as well to exclude holidays Exce...