Forum Discussion
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
This part TEXT($BA3,$BA3-$D3) makes no sense. Just $BA3-$D3 will work.
6 Replies
This part TEXT($BA3,$BA3-$D3) makes no sense. Just $BA3-$D3 will work.
- 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=D3-C3 and apply General format
- Thank you Detlef Lewin (if that is your real name) Really though, that worked and corrected the issue, thank you.
.jpg){kind=link}