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.

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

--
HTH

Bob Phillips

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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

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

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