Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Date difference in weeks

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.

Date difference in weeks.png

 

Thanks in advance

2 Replies
shiveshsingh
Master
Master

Try This

 

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

jonathandienst
Partner - Champion III
Partner - Champion III

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)

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein