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
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