Good afternoon! I have a s/s listing jobs and completion dates over a period of several years. I need to find the FY for the date each job was completed. The FY period is from 01 Oct 20xx to 30 Sept 20yy. So, I'm looking for a formula that will return the FY of oh, lets say, 28 Oct 2012 as FY13. Or simply 13. The FY part would be a bonus but is not required.
Bookmarks