Formula for the weeks calculation.

[asyamonique]

Good Day,
With below formula I do get the calculation for the time passed from beginning as a year, mnth and days...
Is it possible to calculate also total weeks to get as one result.
Simply the formula will show only total weeks from btw selected dates.
Thanks

=IF(B17="","",DATEDIF(B17,TODAY(),"Y") & " Years, " & DATEDIF(B17,TODAY(),"YM") & " Months, " & DATEDIF(B17,TODAY(),"MD") & " Days")

 

[James006]

Hi,

To calculate weeks between your dates, you can test

=INT((Today()-B7)/7)