Forum Discussion
Gonzo45
Nov 05, 2021Copper 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...
- Nov 05, 2021
This part TEXT($BA3,$BA3-$D3) makes no sense. Just $BA3-$D3 will work.
Detlef_Lewin
Nov 05, 2021Silver Contributor
This part TEXT($BA3,$BA3-$D3) makes no sense. Just $BA3-$D3 will work.
- peterrabbittastesDec 27, 2021Copper ContributorPlease 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- SergeiBaklanDec 27, 2021Diamond Contributor
=D3-C3 and apply General format
- peterrabbittastesDec 27, 2021Copper ContributorThank you so much!
IDK what general format means, I'm a novice to excel
- Gonzo45Nov 05, 2021Copper ContributorThank you Detlef Lewin (if that is your real name) Really though, that worked and corrected the issue, thank you.