Stop a formula if a cell has certain text but retain figure

**Cartmel** · 02-26-2021, 09:07 AM

Hello All, I have a question which I will try and keep as simple as possible.

I have certain cells counting up from a date which i would like to stop counting when certain criteria are met.

Example:

If cell F2 has no date then T2 is to count the number of days from the date in D2.
If F2 has a date then T2 is to stop counting the date in D2 but retain the value, same thing should happen when a date is entered into K2.
If a date is in F2 then U2 is to start counting from that date and stop once a date has been entered into K2, U2 is to retain value.

Hope this makes sense, also D2 will always have a date.

Thank you in advance for any help.

Nick

**6StringJazzer** · 02-26-2021, 09:38 AM

What do you have in T2 and U2 right now?

In almost all cases, freezing a value that is returned by a formula once some event occurs requires VBA. For us to give you a working solution, please provide your file. See yellow banner at the top of the page.

**Cartmel** · 02-26-2021, 10:16 AM

I have attached an example

**6StringJazzer** · 02-26-2021, 11:09 AM

I focused on your description using "counting", where it seems like all you are really doing is showing elapsed days between dates.

If a date is placed into F2, wouldn't T2 be the elapsed time from D2 to F2?

Similarly, if a date is placed in K2, wouldn't U2 be the elapsed time from F2 to K2?

If so then these formulas would apply, without having to use VBA:

T2: =IF(D2="","",IF(F2="",TODAY(),F2)-D2)

U2: =IF(F2="","",IF(K2="",TODAY(),K2)-F2)

Stop a formula if a cell has certain text but retain figure

LinkBack

Thread Tools

Rate This Thread

Display

Stop a formula if a cell has certain text but retain figure

Re: Stop a formula if a cell has certain text but retain figure

Re: Stop a formula if a cell has certain text but retain figure

Re: Stop a formula if a cell has certain text but retain figure

Thread Information

Users Browsing this Thread

Similar Threads

Stop a formula if a cell has a certain text

Retain time format whilst formatting cell to text?

Replace text string in a cell and retain rich text formatting (Excel 2013)

Increment a cell value until it satisfies a criteria and stop and retain the minimum value

Unable to figure out a macro to retain font in grey but change to black once overwritten

[SOLVED] Cannot get a cell to retain formatting when a part of a text string

Formula when I enter a number or text in cell D3 a figure is automatically entered in

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions