Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try This
=Date(Add Date-[last date of CM],'DD')/7
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)