diffWeeks()

returns the number of whole weeks between two dates the result is positive when date2 is after date1 , and negative when date2 is before date1 syntax diffweeks(date1, date2) parameters parameter type description date1 date docid\ xtaqdzvlbtakjxrnpfwe9 the date from which counting begins date2 date docid\ xtaqdzvlbtakjxrnpfwe9 the date at which counting ends return type number docid\ uci5tctfvbhonej6zqijg the number of whole weeks between the two dates partial weeks are not counted examples diffweeks('2025 01 01', '2025 12 31') returns 52 diffweeks('2025 01 01', '2025 01 08') returns 1 because there is exactly one full week between the two dates related carrot diffdays() docid\ prpri026iiuebphknzw8u returns the number of days between two dates diffmonths() docid\ jo2ubeint1mtnw1xnl7 2 returns the number of whole months between two dates diffyears() docid\ xtagbzq7ngaiktsg0paom returns the number of whole years between two dates