Fiscal Week Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Morning

I have a textbox that displays a user entered date. When this date is
entered I want another text box to display the week number for that date.
However, this needs to be based on the fiscal year with the year starting on
27/03/05 so this will be week 1.

Any help on how I go about this will be much appreciated.

Thank You
 
WeekNumber = DateDiff("ww", #3/27/2005#, TextBoxDate) + 1

This will only work if your TextBoxDate is always greater or equal
27/03/2005 so you might want to validate before calculating week number.
 
Back
Top