Date Intervals

J

james

=IF(B6>1,TODAY()-B6,0)

using this formula to calculate the number of days that
have passed, how do I stop the counting once a received
date is input another cell? thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Find last date of sold stock and sold price. 2
Percentage of month passed formula 1
Countif or other formula needed for multiple data/critera results 3
Countdown macro - display settings 2
Calculating days spent to complete a task 2
Calculate average in intervals 1
Text duplication question 0

Top