Financial Week numbers

[Snowfire]

I am trying to code a British Financial Week Number Function. ie. an
April to March rotation. The Jan to December is quite common but I can
find no reference to the Fiscal week numbers.
Also is it my imagination or has this group had a drastic reduction
of past history. I seldom find any information I search for now days?
Without wanting to upset anyone, it has almost become a "chocolate
saucepan".

 

[Snowfire]

One question first: April 6th is the beginning of the UK financial tax
year. In 2007, the 6th fell on a Friday. On what date did week *::2::*
of the financial year *begin*?

Thanks for the reply..... looking at old diaries I think it must have
been the 16th April...... I will confirm when I get back to work
tomorrow.

 

[Patrick Molloy]

try this

Function WeekNumber(thisdate As Date) As Long
Dim startdate As Date
startdate = DateSerial(Year(thisdate), 4, 4)
If startdate >= thisdate Then
startdate = DateSerial(Year(thisdate) - 1, 4, 4)
End If

WeekNumber = Int((thisdate - startdate - 1) / 7) + 1

End Function

 

[Snowfire]

Thank you both for the input....... Patrick, yours works for me
great!