Prev: Coloring
Next: Complex If
From: exalan on 5 Apr 2010 11:21
Hi,

When I use the weeknum formula to calculate the week number on today's date
(5th April 2010), the result is 15 (week no.15) irrespective of the return
type 1 or 2. However, according to the Calendar in my Lotus Notes, the week
starting 5th April 2010 is Week no.14.

I think the difference in Week No. between the two is due to cumulative
effect of Week no.1 in Lotus Notes starts from 4th January 2010 whereas
Excel's Weeknum starts Week no.1 from 1st January 2010.

May I know which is the correct Week Number for 5th April 2010, Week no.14
or Week no.15?

Many thanks...
--
exalan
From: Niek Otten on 5 Apr 2010 11:27
<y I know which is the correct Week Number>

That depends on your definition of Week Number.

To learn all about week numbers and Excel, read this:

http://msdn.microsoft.com/en-us/library/bb277364.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"exalan" <exalan(a)discussions.microsoft.com> wrote in message
news:E61E2F4B-C3A3-4B93-8035-B0AF86FD6BD3(a)microsoft.com...
> Hi,
>
> When I use the weeknum formula to calculate the week number on today's
> date
> (5th April 2010), the result is 15 (week no.15) irrespective of the return
> type 1 or 2. However, according to the Calendar in my Lotus Notes, the
> week
> starting 5th April 2010 is Week no.14.
>
> I think the difference in Week No. between the two is due to cumulative
> effect of Week no.1 in Lotus Notes starts from 4th January 2010 whereas
> Excel's Weeknum starts Week no.1 from 1st January 2010.
>
> May I know which is the correct Week Number for 5th April 2010, Week no.14
> or Week no.15?
>
> Many thanks...
> --
> exalan

From: exalan on 5 Apr 2010 12:53
Hi Niek

Many thanks for the quick response. I now understand why.

Thanks again

--
exalan


"Niek Otten" wrote:

> <y I know which is the correct Week Number>
>
> That depends on your definition of Week Number.
>
> To learn all about week numbers and Excel, read this:
>
> http://msdn.microsoft.com/en-us/library/bb277364.aspx
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "exalan" <exalan(a)discussions.microsoft.com> wrote in message
> news:E61E2F4B-C3A3-4B93-8035-B0AF86FD6BD3(a)microsoft.com...
> > Hi,
> >
> > When I use the weeknum formula to calculate the week number on today's
> > date
> > (5th April 2010), the result is 15 (week no.15) irrespective of the return
> > type 1 or 2. However, according to the Calendar in my Lotus Notes, the
> > week
> > starting 5th April 2010 is Week no.14.
> >
> > I think the difference in Week No. between the two is due to cumulative
> > effect of Week no.1 in Lotus Notes starts from 4th January 2010 whereas
> > Excel's Weeknum starts Week no.1 from 1st January 2010.
> >
> > May I know which is the correct Week Number for 5th April 2010, Week no.14
> > or Week no.15?
> >
> > Many thanks...
> > --
> > exalan
>
 | 
Pages: 1
Prev: Coloring
Next: Complex If