Tax Year dates

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Difference in Complete Tax Years 1
Compute Tax? 0
SUM and IF using two date ranges 2
please suggest a formula 2
tax 2
Complete Tax Years 1
Tax Periods 1
Allocate an income payment over a date range (tax years) 7

Back
Top