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...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 04, 2021

hschdk 

If dates are in A1 and B1 that will be =B1-A1

Second didn't catch what do you mean

  • 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

      • hschdk's avatar
        hschdk
        Copper Contributor
        Oct 04, 2021
        Can't get it to work🤔

Resources