Multiple Conditions for calculating weeks between 2 dates

I am creating a waiting list calculation with the following headings;   A B C 1 Date Referred Length Waiting to Activate Date  Activated 2 01/06/2022 [Formula] 5  01/07/2022   ...