yogi_How To Allocate Tax Month Number For British Tax Year That Begins On Apr 6th

Google Spreadsheet   Post  #2512

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-10-2018

question by: Russ Walker 7

Google Spreadsheet   Post  #2511

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     

question by: Jo Smith9
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/MeIq1I8-QWg;context-place=forum/docs

How do I allocate a number to a month? (tax calendar run)

I'm finding this so tricky! if there are better ways to do this, I'm happy to consider it!

The Problem

The UK tax calendar runs from 6th April 2017 to 5th April 2018. It starts on the 6th of each month and ends on the 5th of the next month. TBH, I don't mind if your solution runs from 1st of the month to the end date of the month.

6th April 2017 to 5th May 2017 is Tax Month #1

6th May 2017 to 5th June 2017 is Tax Month #2

...

6th Dec 2017 to 5th Jan 2018 is Tax Month #9

...

6th Mar to 5th April 2018 is Tax month #12

I want to have a hidden column which would have the relevant tax month so that a Pivot Table could - in an ordered fashion - show the costs related to that month.

For Example

04/04/2018	£ 8.64	WholsaleRUs	Stock
04/04/2018	£ 5.50	Office Plus	Stationary
13/12/2017	£ 2.50	WholsaleRUs	Stock
13/02/2018	£ 6.98	MiniMart	Stock

So looking at the above table, the first two rows should be Tax Month #12, the third would be tax month #9 and the last would be tax month 11.

Thank you!