Excel Snippets: Get First and Last Dates of UK Tax Year

It doesn’t come up very often as I do a lot of work using SQL Server rather than Microsoft Excel, but every so often I do need to do some date manipulation in Excel.

In the previous article of the [series-link-title /] series, I showed how to get the first and last dates of the calendar year. One of the peculiarities of the UK, is that our tax year always starts on the 6^th of April. The previous article on calendar year is still applicable to calculating the first and last dates of the tax year, with a couple of tweaks.

The YEAR function can be used to extract the year from a supplied date:

=YEAR(TODAY())

The date function is supplied three parameters: year, month and day.

The output of the YEAR function gives us the first parameter and for the month and day of the first day of the UK tax year we can supply the month of 4 and the day of 6:

=DATE(YEAR(TODAY()),4,6)

To get the last day of the UK tax year, the year is still calculated using the YEAR function, but we do +1 to increase it by one year, the month parameter is set to 4 and the day to 5:

=DATE(YEAR(TODAY())+1,4,5)

Read original post Excel Snippets: Get First and Last Dates of UK Tax Year at azurecurve|Ramblings of an IT Professional