I am building a spreadsheet that tracks the amout of days an item has been on order. I have found both formulas to count the amout of days from a date and between two days but I have not found a formula that does them both. What Im looking for is to be able to enter in an order date and have the days count till I enter a received date which would be the amout of time between dates.
For the bonus question.... I would also like the row to highlight a color to viusually note received.
All help is welcome and appreciated!!!