SOLVED

Excel date issue (days between 2 dates)

Copper Contributor

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

@Gonzo45 

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

Thank you Detlef Lewin (if that is your real name) Really though, that worked and corrected the issue, thank you.
Please help:
calculating days between two dates excel
The result is only showing dates not days.
I've already used the =DATEDIF(C3,D3, "d") formula

@peterrabbittastes 

=D3-C3 and apply General format

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

@peterrabbittastes 

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

S1024.png

1 best response

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

@Gonzo45 

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

View solution in original post