Someone here could help me to calculate the number of weeks between two dates?
Like for example: =Week(DATE1 BETWEEN DATE2)
Thank you, hope that you can understand my question.
If I understood you well, can't you just get it dividing the difference (in days) by 7?
FLOOR((DATE2 - DATE1) / 7)
This will give you the number of complete weeks between both dates.
Thank you a lot!
Retrieving data ...