Stop counting days when date entered in another cell

Hi

I am having a mind blank - and cant figure out how to fix the problem.

in

i am populating a document register when tracks date received, when sent for review, date due, how many dates left of review and date returned.

G1 has date received - free text
H1 has date sent for review - free text
I1 is due date - formula =IFBLANK(G1),"",=G1+14)
J1 is days remaining - formula =IF(I1="","",I1-TODAY())
K1 is returned date - free text

i want J1 to stop calculating when K1 has date entered

what do i need to do?

Dont know a function named IFBLANK....
why dont you just upload the sample file instead of letting others do that for you?

Thank you for your quick reply.

Apologies when i said "free text" i just meant that the user can enter any value.

So to answer your question - K1 can be any date as it will be the date that the information, so it could be today, tomorrow or in 3 weeks time.

Hope that makes sense, i can add a sample if needed?

belinda when i searched this forum i come across so many of your responses and it seems you come across very rude on nearly every post

yes - again sorry.

I am working between 3 different laptops and in between meetings, apologies again a type on my part.

G1 has date received - date entered (can be any date)
H1 has date sent for review - date entered (can be any date)
I1 is due date - formula =IF(ISBLANK(G1),"",=G1+14)
J1 is days remaining - formula =IF(I1="","",I1-TODAY())
K1 is returned date - date entered (can be any date)

Originally Posted by 6StringJazzer

Do you mean

Formula:

Please Login or Register  to view this content.

ive reposted at the bottom of the post - if you want me to add a sample workbook let me know.

Originally Posted by lucecal

belinda when i searched this forum i come across so many of your responses and it seems you come across very rude on nearly every post

You're welcome to send me where I was rude, sorry if you were offended but I do believe that a sample file is mandatory to resolve your problem faster.

Originally Posted by 6StringJazzer

Welcome to the Forum lucecal !

We need just a little more information to determine if this can be done with formulas, or if it requires VBA.

First, you refer to "free text." What do you mean by that? A cell containing a date should be a date value, not text.

When K1 is entered, does the user enter today's date, or can it be any date? If the user just enters today's date into K1 then your J1 formula can be

Formula:

Please Login or Register  to view this content.

However, if K1 can contain any date at all, then you need to use VBA to fix the value in J1. This is not especially difficult but it will require converting your file to macro-enabled.

thank you for responding - apologies I didnt attach a sample workbook. I am working with very sensitive data so thought i would see if i could get a resolution without transferring my information to a sample first.

Free text i meant as in eneter any date and yes K1 can be any date,