Getting a cell to stop counting numbers

[Chris87]

Hi, Appreciate any help as I am not an Excel guru.
I have a sheet that I use, column C is called "date Stopped", column D is "Date Released" and Column E is "Number of days stopped". I currently use the formula =TODAY()-C1 etc... that calculates the number of days in Column E. I want a formula that will still do this but once I enter a date into into Column D, Column E will then stop counting.
Any help is greatly appreciated.

 

[RobP]

Hi,

welcome to the forum. Its not quite clear why you use today() to calculate the number of days, as that will keep counting as you say.

But if you want to find the difference between date in Col C and date in Col D, you could use simply this:

Book1
	A	B	C	D	E
1
2			01/05/2024	15/05/2024	14
3
Sheet1

Cell Formulas
Range	Formula
E2	E2	=D2-C2

you need to manually enter dates in Col C and Col D of course ... any help ?

Rob

 

[Chris87]

Hi Rob, thanks for your reply. I use the Today() formula in column E as it's a way of keeping track on how many days (sometimes this is many months).
Is there anyway I can still have the cell to count the number of days but as soon as I enter a date into column D it stops counting and works out how many days between the date in column C and the date in Column D?

 

[RobP]

ok, try this

Book1
	B	C	D	E
1
2		01/05/2024	15/05/2024	14
3
Sheet1

Cell Formulas
Range	Formula
E2	E2	=IF(D2="",TODAY()-C2,D2-C2)

 

[Chris87]

That's Brilliant Rob! Thanks very much!

 

[RobP]

your welcome.

thanks for the feedback

Rob