First the DATE function creates the date 5. Hi everyone I am looking for an excel formula to calculating the number of days from years between Start date end date Example. The formula in cell A6 uses Excels DATE function to ensure that the date 10152015 is entered and stored as a date value.
42 DAYSA2A3 Finds the number of days between the end date in A2 and the start date in A3 364.
My start date is 06192020 My end date is 06202023 I would to know on this example the number of days from year 2020 from start date. Next in column B1 type in the formula. Switch to the formula bar. 2Then select the formula cell and click Short Date from the General drop-down list under the Home tab to convert the number to date format see.