Tax Year dates

Giganews Newsgroups
Subject: Tax Year dates
Posted by:  Dave (dwbg225…@blueyonder.co.uk)
Date: Fri, 31 Oct 2003

A spreadsheet I use lists various policies and has a column each for the
month & year of the policies.  Is there a formula to have another column
which will show the (UK) tax month - where calendar month April = tax month
01, May = 02, etc etc.

I've tried IF formulas, so if Calendar Month is April, show 04 for Tax
Month, and so on, but IF formulas only allow for 7 arguments whereas I would
need 12.

Any help will be much appreciated.
TIA
Dave

Replies