How do i calculate fiscal week of the year

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

evlai@hotmail.com - 21 Sep 2005 15:56 GMT

Hi,

I would like to know how to calculate fiscal week of the year. for
example, the first week of the year is started from Feb 1, 2005 instead
of Jan.

Reply to this Message

Bob Phillips - 21 Sep 2005 16:24 GMT

=INT((A1-DATE(2005,2,1))/7)+(WEEKDAY(A1)<7)

Signature

HTH

Bob Phillips

> Hi,
>
> I would like to know how to calculate fiscal week of the year. for
> example, the first week of the year is started from Feb 1, 2005 instead
> of Jan.

Reply to this Message

evlai@hotmail.com - 22 Sep 2005 13:58 GMT

Thanks Bob, i really appreciate it, i will try to see of this works for
my file

Reply to this Message

evlai@hotmail.com - 22 Sep 2005 14:03 GMT

Thanks Bob, i really appreciate it, i will try to see of this works for
my file

Reply to this Message

evlai@hotmail.com - 22 Sep 2005 14:04 GMT

Thanks Bob, i really appreciate it, i will try to see of this works for
my file

Reply to this Message