Calculating weeks from number of days between two dates

[chrislyonsuk]

Hi, 

Can some please clarify how to convert the number of days between two dates into weeks?

We have date A and Date B. (01/01/2021 & 22/01/2021) that are 21 days apart. how do I convert the days into '3 weeks' in order to display the time taken into a Barchart as weeks?

Thanks

[Anil_Babu_Samineni]

Try like this?

Floor(Fabs(Interval(Date#([date A], 'DD/MM/YYYY')-Date#([Date B],'DD/MM/YYYY'), 'DD'))/7) & ' Weeks' as WeekField