Date difference in weeks

[mahitham]

Hi Experts,

Can any one please help me on below requirement.  I have two date fields like Add Date and [last date of CM]. From these two dates please help me derive the Date difference in Weeks.

Thanks in advance

[shiveshsingh]

Try This

=Date(Add Date-[last date of CM],'DD')/7

[jonathandienst]

You don't need the Date() function here. It is simply a format function.

To round to nearest integer:

=Round((Add Date-[last date of CM])/7)

Or to include the partial week:

=Ceil((Add Date-[last date of CM])/7)

Or to include only complete weeks:

=Floor((Add Date-[last date of CM])/7)