![]() For example if cell B1 contained a holiday your formula would read =NETWORKDAYS(A1,A2,B1). This third argument is a date or number of dates that are holidays or non-work days. This formula will also take a third argument. ![]() ![]() When using the NETWORKDAYS function send your most current date as the first argument and your oldest date as the second argument. In the example below find the number of work days between the two dates in A1 and A2 by entering the formula =NETWORKDAYS(A1,A2) into A3. 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |