Re: Week Numbers for Tax Year

Hi

How do you calculate that?
I just loaded Sage Payroll, and for 07 Jun 2007 it gives Tax week 9. As
Sage is probably the widest used payroll package in the UK, I don't
think they will have got it wrong<g>
Tax week 10 commences on 08 Jun 2007

--
Regards

Roger Govier


"mlv" <mike.safetycatchvincent@xxxxxxxxx> wrote in message
news:f48vlf$gbm$1@xxxxxxxxxxxxxxxxxxxx
Roger Govier wrote:

With your formula, you get negative week numbers once you get past
December of the year, gradually reducing from -65 to -52.

I think the formula is nothing more complicated than
=INT((A1-DATE(2007,4,6))/7)+1



Rick Rothstein wrote:

=INT((DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))-DATE(YEAR(A1) + (32 *
MONTH(A1) + DAY(A1) < 134), 3, 6))/7)+1

For today's date (7 June 2007) both of the above formulas give the
answer 9.

However, I calculate that this week is at least UK Tax Year Week No.
10, or possibly 11.
--
Mike
-Please remove 'safetycatch' from email address before firing off your
reply-



.

Relevant Pages

  • Re: Week Numbers for Tax Year
    ... Although I said I used Sage for a quick check up (saved me hunting ... You cannot therefore use a constant offset for Tax week number compared ... with ISO week number. ... This week number routine is required for an Excel invoice sheet that I ...
    (microsoft.public.excel)
  • Re: Week Numbers for Tax Year
    ... you should ask your client which tax week he is actually ... Depending upon which day of the week your client makes his payments. ... Although I said I used Sage for a quick check up (saved me hunting ... compared with ISO week number. ...
    (microsoft.public.excel)
  • Re: Week Numbers for Tax Year
    ... Sage is probably the widest used payroll package in the UK, ... This week number routine is required for an Excel invoice sheet that I use. ... I always use ISO week numbers on my invoices. ... My main client says they use Tax Year week numbers, ...
    (microsoft.public.excel)
  • Re: Sage Instant Accounts (V12)
    ... I need the information for Company Tax Returns - I am an exceptionally ... I am trying to get the information required from Sage. ... Profits no where near £10k - not even half of ...
    (uk.business.accountancy)
  • Re: Sage MMS - item master table / structure
    ... DoobieDo wrote: ... Server tables. ... We deal with Sage Line 200 and 500 ... we deal with tax and accountancy matters, ...
    (uk.business.accountancy)