Insert current week number in Microsoft Word

Question

Is there any way in MS Word to insert current week number? I need to make a template for the weekly report, and I'd like the week number field to be filled in automatically... What I need is something similar to Excel WEEKNUM() function.

Answer 1

This can be done with a VB Macro. This macro will insert the current week after the current selection.

Sub adddate()
    Selection.InsertAfter Text:=DatePart("ww", Date)
End Sub

Answer 2

If you want it in Word you need a Macro, but if you use Excel this might work.

Calculating the difference between each pair of dates listed in columns

A & B.

Solution:

To calculate the difference in days, use the DATEDIF function as shown in the following formula:

=DATEDIF(A2,B2,"d")

To calculate the difference in weeks, use the INT function as shown in the following formula:

=INT((B2-A2)/7)