calculate number of days from current date

Dear Expert,

From the attached sheet, a column "Launch Date" is available with list of date and time.

Requirement is to add one column after column K and then rename as 'Interval'.

This interval should contain number by subtracting Launch date from current date. i.e.
Interval = current date- Launch date

I am able to do using formula but I require to automate it without doing the same task. is it possible to develop a small macro so as to fulfil the requirement.

Thank you expert in advance

something like this?
L26: =DATEDIF(K26,TODAY(),"d") and copy down

I know this is not a VBA solution

Thank You sandy for the solution.
I kept the macro like below. is it fine ?

Please Login or Register  to view this content.

I am not VBA master but if it works for you that's good.

You could use the following, if you would like it to be a bit faster:

Please Login or Register  to view this content.

Thank you bkm and Sandy for your great help

You are welcome and thanks for the feedback