Forum Discussion
Calculating multiple dates in excel
Thank you for your response and feedback. The formula I originally inserted originally came from an excel macro that we use that does work but in a slightly different situation.
I tried both formulas you provided and they do work , however, even though I changed the dates in Column B to text, any dates in July in Column B, are still not matching with the number I get in Column G vs what the vendor has listed :
Lenni099 Riny is absolutely right that your data in columns B through E should be dates, not text. His formula is partially correct, but what I see is that (Correct) Charge Days is the number of days encompassed by these two dates, inclusive:
- the later of Gate in and INV START DATE
- the earlier of INV END DATE and Gate Out
Therefore, the formula for row 3 should be something similar to:
=MIN($D2,$E2) - MAX($B2,$C2) + 1
In the future, please attach a small spreadsheet file (enough to demonstrate the issue at hand; be sure to remove any sensitive data) rather than making us redo the data entry.