Calculate week in Word document based on date entered into same document

ArviLaanemets · #1 11-15-2019, 06:45 AM

Hi

Into Word document, document date (in format dd.mm.yyyy) is entered. Elsewhere in same document I need an ISO weeknumber of this date displayed. Probably an UDF must be defined to calculate it - something like (on fly)

Code:

Public Function WeekNo(parDate As Date) As Integer
    WeekNo = DatePart(ww, parDate, 2, 2)
End Function

Ideally, in case the date is edited, the weeknumber in document must update too.

Is this possible?

a) in regular Word document;
b) in Word template only.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
split word document based on bookmarks with each new document title of the bookmark	megatronixs	Word VBA	9	09-05-2020 02:29 PM
data entered in one workbook should be updated in other relevant workbook based on the date	vedha	Excel	0	04-24-2015 08:45 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Formula to auto calculate Day of the week based on Date	prasad@dmci.ca	Excel	1	11-29-2011 01:05 PM