tax

[adn4n]

Hi there i am currently inserting the months for the tax periods, s
that a tax code can be assigned depending on what months the person
tax is in.

Therefore the tax year starts in April, so for example July is ta
period 05. How do i do a forumla to explain this, can anyone help me
Thank you

 

[Frank Kabel]

Hi
one way:
- create a lookup table with the month names and your tax period
- use VLOOKUP to get the associated values

 

[Bob Phillips]

=CHOOSE(MONTH(A1),10,11,12,1,2,3,4,5,6,7,8,9)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)