Forum Discussion

hschdk's avatar
hschdk
Copper Contributor
Oct 04, 2021
Solved

Data to days

Hello

 

How do i get the numbers of days between 2 dates?

 

Example:

 

17-06-2021 - 19-06-2021 i want to count the days between the 2 dates(numbers of days 2). And if possible to always use the date of the day

 

Best Regards

Henrik

excel

8 Replies

    • hschdk's avatar
      hschdk
      Copper Contributor
      Oct 04, 2021
      I want to count the days between 2 date format

      example:

      A1; entry date=17-06-2021
      B1: Salesdate= 20-06-2021
      C1= Numbes of dayes between(want to have excel to return the numbes) 3 days
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Oct 04, 2021

        hschdk 

        Days in Excel are sequential integers numbers starting from 1 which is Jan 01, 1900 (on Windows).  Format only defines how to show such numbers. If you enter =TODAY() and apply General format that will be

Resources