Here write DATEDIF A1B1d A1 being the cell with start date and A2 with the end date It will output the number of days between the two dates. This formula links to specific cells in the worksheet to source the formula parameters however you can also enter the number of days you want to subtract and the date that you want to subtract the days from by directly entering these parameters into the formula eg. Use a different formula to find days.
Upon hitting enter field B1 should read 01282016.
The subtraction formula in cell A6 makes use of these numbers to find the number of days between the two dates 43405 - 42292 1113. Formula NETWORKDAYSstart_date end_date holidays. First the DATE function creates the date 5. Now we need to find the number of remaining days.