SOLVED

New Contributor

# 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

8 Replies

# Re: Data to days

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

Second didn't catch what do you mean

# Re: Data to days

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

# Re: Data to days

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

# Re: Data to days

Can't get it to work
best response confirmed by hschdk (New Contributor)
Solution

# Re: Data to days

Now it works thank yo very much for your help

# Re: Data to days

@hschdk , you are welcome, glad to help