Conditional Formulas

0

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?

Answer
Discuss

Discussion

Start counting what?
don (rep: 1382) Jan 10, '18 at 12:52 pm
Add to Discussion

Answers

0

Try this formula. It expects the start date to be in A1.

=$A1+MAX(TODAY()-INT($A1),5)
Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login