If your result appears as a date or you want more information about how Excel stores dates see the note below.įinding the number of work days between two dates is made easy using Excel’s built in NETWORKDAYS function. For example in the spreadsheet below to find the difference between the two date you would enter the formula =A2-A1 into cell A3. In Excel finding the number of days between two dates is as straight forward as subtracting the cell with the oldest date from the cell with the most current date. Why don’t my results look right and end in the year 1900?
Guide to Simple Date Operations in Microsoft ExcelĬalculate the number of days between two datesĬalculate the number of work days between two datesĬalculate the number of months between two datesĬalculate the number of months between two dates in different yearsĬalculate the number of years between two dates
