I am trying to figure out how to take a fiscal year field and month field and create a date in xx/xx/xxxx format in Excel.
The fiscal year is October -September. If the month is October November or December, the date will correspond to the previous year of the fiscal year (ie if the month is "October" and the fiscal year is 2010- the date would read "10/1/2009").
Solved by Z. H. in 26 mins