Prev: My cursor always in selection mode,wat about other cursor option
Next: Re-installed Office 2003 and the licensing agreement pops up each
From: Jon on 1 Mar 2010 19:06
Hi
I have some data with the date reprisented by a week No
I want to make a date on the Monday of that week in a seperate colum any
advise please
From: Bernd P on 1 Mar 2010 19:19
Hello Jon,

As given by some guy called daddylonglegs:
[citation from
http://www.excelforum.com/excel-general/588185-formula-for-getting-data-from-week-number-reverse-weeknum.html
]
=DATE(A1,1,A2*7-2)-WEEKDAY(DATE(A1,1,3))

A1: Year
A2: Weeknum in year (ISO)

Regards,
Bernd
From: Jon on 1 Mar 2010 22:34
Sorted Ta

"Bernd P" wrote:

> Hello Jon,
>
> As given by some guy called daddylonglegs:
> [citation from
> http://www.excelforum.com/excel-general/588185-formula-for-getting-data-from-week-number-reverse-weeknum.html
> ]
> =DATE(A1,1,A2*7-2)-WEEKDAY(DATE(A1,1,3))
>
> A1: Year
> A2: Weeknum in year (ISO)
>
> Regards,
> Bernd
> .
>
 | 
Pages: 1
Prev: My cursor always in selection mode,wat about other cursor option
Next: Re-installed Office 2003 and the licensing agreement pops up each