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
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