Select cell D2, which is the first blank cell in the Duration column.Įxcel displays the result as the number of days between the two dates (104). Ĭalculate the number of days between two dates In the sheet, select cell A1, and then press + V.
Use the provided sample data and the following procedures to learn how to calculate dates in a project schedule.Ĭopy the following sample data to cell A1 on a blank sheet. For example, you can quickly subtract one date from another date, or calculate the duration of items on a project schedule. You can quickly find the difference between two dates, control the format of the result, and extend the calculation to a list of dates.
Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 More.
