Financial Week numbers

  • Thread starter Thread starter Snowfire
  • Start date Start date
S

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".
 
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*?
Click to expand...

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.
 
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
 
Back
Top