Freeze today function by entering date in another column (non-VB solution?)

[Sam Millican]

Hi All

I have been trying to think of a solution to my problem with only basic knowledge of Excel, and unsurprisingly have come up short.

My spreadsheet is tracking patients against a treatment target date, I am using the formula =K3-TODAY() (K3 being the treatment target date) so the spreadsheet automatically updates counting down the days to said date.

Essentially, I am looking to freeze this function once I enter a date in another cell (i.e. date drugs were administered) so that the days remaining to treatment target date is locked and will no longer update.

Any help would be greatly appreciated!

KR

Sam

 

[JeffTupas]

Hi, this actually helped me however I'm getting a negative value on the number