Hi there,
I have a spreadsheet that contains data extracted from a Sage Ledger report. I would to look at the date column and in another column return a particular Financial Year relative to the date.
In the example below, I have in column B what the Financial Year (FY) should look like. The FY runs from 1st July to 30th June each year and so I need to assess each date in column A and transpose it to the correct FY. I can then sort column B into the FY very easily.
Any help would be gratefully received as I have many lines of data.
Regards
Ben
I have a spreadsheet that contains data extracted from a Sage Ledger report. I would to look at the date column and in another column return a particular Financial Year relative to the date.
In the example below, I have in column B what the Financial Year (FY) should look like. The FY runs from 1st July to 30th June each year and so I need to assess each date in column A and transpose it to the correct FY. I can then sort column B into the FY very easily.
Any help would be gratefully received as I have many lines of data.
Regards
Ben
A | B | |
1 | Date | FY |
2 | 01/12/2007 | 2007/8 |
3 | 06/03/2008 | 2007/8 |
4 | 01/07/2008 | 2008/9 |
5 | 30/01/2009 | 2008/9 |
6 | ||
7 |