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.
peterrabbittastes
Dec 27, 2021Copper Contributor
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
calculating days between two dates excel
The result is only showing dates not days.
I've already used the =DATEDIF(C3,D3, "d") formula
SergeiBaklan
Dec 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- HansVogelaarDec 27, 2021MVP
General is the first item in the Number Format dropdown in the Number group of the Home tab of the ribbon: