But unlike the DAYS function, it can do more than that. Using the DATEDIF FunctionĭATEDIF function (derived from Date Difference) also allows you to quickly get the number of days between two dates. You can read more about the Days function here. If you want both the days to be counted, you need to add 1 to the result of Days function. This means that if the dates are and, it will return 1. Just make sure these dates in double-quotes is in an accepted date format in Excel.ĭays function gives you the number of days between two dates. Note that you can also manually specify the dates in the Days function by putting it in double-quotes. The following formula will give you the total number of days between the two dates: =DAYS(B2,B1) You need to specify the ‘Start Date’ and the ‘End Date’ in the Days function, and it will give you the total number of days between the two specified dates.įor example, suppose you have the start date is in cell B1 and End Date is in cell B2 (as shown below): Using the DAYS FunctionĮxcel DAYS function can be used to calculate the total number of days when you have the start and the end date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |