Because in Microsoft Excel stores every day as a unique serial number starting with 1 representing 1 January 1900. Calculate the distance between two dates in Excel Subtract the direct dateĪssuming that in cell A1 is the start date, B1 is the end date, then you can subtract the date directly by entering the formula = B1-A1 the result will be the number of days. Here has shared with you how to subtract days, months and years in Excel, please follow along. You do not know how to calculate and use what function? So invite you and to learn how to calculate the distance between two dates in Excel, except for days, months and years in Excel below. In the process of processing data in Excel you need to subtract days, months and years in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |