SOLVED

# Excel date issue (days between 2 dates)

Copper Contributor

# Excel date issue (days between 2 dates)

All,

I am having an issue with counting days between 2 dates in Excel. Picture provided, but quickly I will overview. I received help here recently on a formula which works like a charm (thank you) but problem is when the 2 dates are 10 days apart, Excel reverts to144494 for the days between (I tested this a couple of times to verify it recurred in different columns/rows). The date columns are set to "Date" and the "days between" column (BB) is set to "Number" formats respectively. The formula is here:

=IF(\$BA3="","",TEXT(\$BA3,\$BA3-\$D3))  (Also review the picture attached)

If I reverse the "\$BA3-\$D3" in the formula it is the same -144494 just minus (-) in the front.

Thank you for any help.

Gonzo45

6 Replies
best response confirmed by Gonzo45 (Copper Contributor)
Solution

# Re: Excel date issue (days between 2 dates)

This part TEXT(\$BA3,\$BA3-\$D3) makes no sense. Just \$BA3-\$D3 will work.

# Re: Excel date issue (days between 2 dates)

Thank you Detlef Lewin (if that is your real name) Really though, that worked and corrected the issue, thank you.

# Re: Excel date issue (days between 2 dates)

calculating days between two dates excel
The result is only showing dates not days.
I've already used the =DATEDIF(C3,D3, "d") formula

# Re: Excel date issue (days between 2 dates)

=D3-C3 and apply General format

# Re: Excel date issue (days between 2 dates)

Thank you so much!
IDK what general format means, I'm a novice to excel

# Re: Excel date issue (days between 2 dates)

General is the first item in the Number Format dropdown in the Number group of the Home tab of the ribbon:

1 best response

Accepted Solutions
best response confirmed by Gonzo45 (Copper Contributor)
Solution

# Re: Excel date issue (days between 2 dates)

This part TEXT(\$BA3,\$BA3-\$D3) makes no sense. Just \$BA3-\$D3 will work.