Hello,
I need help coming up with a formula. In column A I have various dates that a customer began doing business with us. In column B is the date that that customer began generating revenue. I need to put a formula in column C that calculates the number of days between now and when the customer begain doing business with us (column A) unless there is a date in column B.
Book1.xlsx
In this example I would need a value returned in column C on rows 3, 4, 5, and 7 but not on 2 and 6.
Any help would be greatly appreciated!
Bookmarks