Date Differance collection

hi,
im new to this forum so not sure if this is the place to ask.
i have created a spread sheet to record the difference between todays date to the date a job has been allocated.
my issue is i need to record the figure when its entered and as the date changes it takes this in to account.
is their a way to collect the initial data and avoid the decrease?

thanks.