When a date is entered in one cell I would like to start counting in another cell, but stop counting after day 5. How would I do this?
When a date is entered in one cell I would like to start counting in another cell, but stop counting after day 5. How would I do this?
Try this formula. It expects the start date to be in A1.
=$A1+MAX(TODAY()-INT($A1),5)