Hello,
I am trying to use the date diff function to get the number of years between two dates as a decimal.
For example, I want the datediff function to return 16.353 when I get the difference between 12/31/2018 and 8/23/2002.
My date1 date, 12/31/2018, is saved as a string and returns "12/31/2018".
My date2 date, 8/23/2002, is saved as a string also but is saved as "20020823".
I have tried various formatting changed but I constantly get overflow and type mismatch errors.

I am fairly new to VBA so any help or tips would be greatly appreciated.

Thanks!