Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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: 1989) 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