Thread
:
week No to date
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bernd P
external usenet poster
Posts: 806
week No to date
Hello Jon,
As given by some guy called daddylonglegs:
[citation from
http://www.excelforum.com/excel-gene...e-weeknum.html
]
=DATE(A1,1,A2*7-2)-WEEKDAY(DATE(A1,1,3))
A1: Year
A2: Weeknum in year (ISO)
Regards,
Bernd
Reply With Quote
Bernd P
View Public Profile
Find all posts by Bernd P