working out days from variable dates

[HellBound]

Hi

I am making a spreadsheet to record patients in my clinic. I can easily work out how long a patient has been in my clinic using
=DATEDIF(K5,TODAY(),"y") &" years, "&DATEDIF(K5,TODAY(),"ym")&" months" where K5 is the date first seen in the clinic.

However, patients will eventually leave the clinic (either death or disease progression), so i will put the date of their last clinic in a different cell (say P5). At that point i want the amount of time in my clinic to stop ie stop using TODAY and use the date in P5.

Can the above formula be adapted to use P5 instead of TODAY only when a value is put in P5?

Hope this is clear.... newbie here!

HB

 

[Fluff]

How about
=DATEDIF(K5,IF(P5="",TODAY(),P5),"y") &" years, "&DATEDIF(K5,IF(P5="",TODAY(),P5),"ym")&" months"

 

[HellBound]

Thank you, nice speedy reply

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Fluff]

Cross posted calculating amount of days

For future reference while we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Dave Patton]

Another idea for your consideration.

T202006b.xlsm
	H	I	J	K					P
4	YearFrac	Days
5	1.6	580	1 years, 6 months	01-Dec-18
6	0.6	215	0 years, 6 months	01-Dec-19					01-Jul-20
7
4b

Cell Formulas
Range	Formula
H5:H6	H5	=YEARFRAC(K5,IF(P5="",TODAY(),P5))
I5:I6	I5	=TODAY()-K5+1
J5:J6	J5	=DATEDIF(K5,IF(P5="",TODAY(),P5),"y") &" years, "&DATEDIF(K7,IF(P5="",TODAY(),P5),"ym")&" months"

 

[HellBound]

Sorry for the cross post, hadn't realised that was a thing, although in hind sight makes sense. Won't do it again.

Thanks to all who took the time to answer

 

[HellBound]

not sure how to close or otherwise mark this threat as closed/solved

 

[Fluff]

We don't mark threads as solved on here. ll we ask is the you post to the thread letting us know that the problem is solved.
As you've already done that, everything's fine