Nov 05 2021 10:56 AM
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
Nov 05 2021 11:11 AM
SolutionThis part TEXT($BA3,$BA3-$D3) makes no sense. Just $BA3-$D3 will work.
Nov 05 2021 11:35 AM
Dec 26 2021 05:28 PM
Dec 26 2021 11:55 PM
=D3-C3 and apply General format
Dec 27 2021 06:00 AM
Dec 27 2021 08:11 AM
General is the first item in the Number Format dropdown in the Number group of the Home tab of the ribbon:
Nov 05 2021 11:11 AM
SolutionThis part TEXT($BA3,$BA3-$D3) makes no sense. Just $BA3-$D3 will work.