Spreadsheet: 68381d1268920757-turning-calendar-month-into-fiscal-year-problem-sample_if
Sheet: Sheet1

 |  |  | Example of how my Fiscal Year column should look like:: |  | 200610 | Fiscal Year 07
 | Month | CY | FY(done manually) |  | 200611
 | 200908 | 09 | 09 |  | 220612
 | 200803 | 08 | 09 | Calendar Year 07 | 200701
 | 200909 | 09 | 09 |  | 200702
 | 200908 | 09 | 09 |  | 200703
 | 200912 | 09 | 10 |  | 200704
 | 200812 | 08 | 09 |  | 200705
 | 200710 | 07 | 08 |  | 200706
 | 200806 | 08 | 08 |  | 200707
 | 200710 | 07 | 08 |  | 200708
 | 201002 | 10 | 10 |  | 200709
 | 200811 | 08 | 09 |  | 200710 | Fiscal Year 08
 | 200711 | 07 | 08 |  | 200711
 | 200902 | 09 | 09 |  | 200712
 | 200712 | 07 | 08 | Calendar Year 08 | 200801
 | 200909 | 09 |  |  | 200802
 | 201002 | 10 |  |  | 200803
 | 200711 | 07 |  |  | 200804
 | 200802 | 08 |  |  | 200805
 | 200909 | 09 |  |  | 200806
 | 201002 | 10 |  |  | 200807
 | 200711 | 07 |  |  | 200808
 | 200905 | 09 |  |  | 200809
 | 200904 | 09 |  |  | 200810 | Fiscal Year 09
 | 200712 | 07 |  |  | 200811
 | 200808 | 08 |  |  | 200812
 | 200904 | 09
 | 200711 | 07
 | 200808 | 08
 | 200910 | 09
 | 200710 | 07
 | 200808 | 08
 | 200902 | 09
 | 200902 | 09
 | 200802 | 08
 | 200902 | 09
 | 200801 | 08
 | 200907 | 09
 | 200904 | 09
 | 200802 | 08
 | 200911 | 09
 | 200905 | 09
 | 200711 | 07
 | 200801 | 08
 | 200901 | 09
 | 200903 | 09
 | 200905 | 09
 | 200908 | 09
 | 200903 | 09
 | 200807 | 08
 | 200802 | 08
 | 200803 | 08
 | 200902 | 09
 | 200912 | 09
 | 200710 | 07
 | 200908 | 09
 | 200803 | 08
 | 200802 | 08
 | 200712 | 07
 | 200903 | 09
 | 200712 | 07
 | 200904 | 09
 | 200910 | 09
 | 200912 | 09
 | 200710 | 07
 | 200809 | 08
 | 200902 | 09
 | 200903 | 09
 | 200806 | 08
 | 200806 | 08
 | 200903 | 09
 | 200811 | 08
 | 200805 | 08
 | 200808 | 08
 | 200810 | 08
 | 200712 | 07
 | 200807 | 08
 | 200903 | 09
 | 200905 | 09
 | 200810 | 08
 | 200802 | 08
 | 200904 | 09
 | 200711 | 07
 | 200810 | 08
 | 200805 | 08
 | 200811 | 08
 | 200901 | 09
 | 200805 | 08
 | 200902 | 09
 | 200807 | 08
 | 200905 | 09
 | 200904 | 09
 | 200809 | 08
 | 200803 | 08
 | 200811 | 08
 | 200711 | 07
 | 200802 | 08
 | 200904 | 09
 | 200804 | 08
 | 200901 | 09
 | 200912 | 09
 | 200910 | 09
 | 200907 | 09
 | 200808 | 08
 | 200812 | 08
 | 200906 | 09
 | 200812 | 08
 | 200910 | 09
 | 201002 | 10
 | 200712 | 07
 | 200710 | 07
 | 200803 | 08
 | 200911 | 09
 | 200908 | 09
 | 200904 | 09
 | 200911 | 09
 | 200802 | 08
 | 200910 | 09
 | 200901 | 09
 | 200908 | 09
 | 200809 | 08
 | 200903 | 09
 | 200909 | 09
 | 200809 | 08
 | 200901 | 09
 | 200804 | 08
 | 200803 | 08
 | 200908 | 09
 | 200807 | 08
 | 200909 | 09
 | 200712 | 07
 | 200904 | 09
 | 200801 | 08
 | 200810 | 08
 | 200803 | 08
 | 200902 | 09
 | 200802 | 08
 | 201001 | 10
 | 200811 | 08
 | 200911 | 09
 | 200903 | 09
 | 200901 | 09
 | 200904 | 09
 | 200811 | 08
 | 200908 | 09
 | 200807 | 08
 | 200806 | 08
 | 200904 | 09
 | 201002 | 10
 | 200906 | 09
 | 200803 | 08
 | 200804 | 08
 | 200904 | 09
 | 200902 | 09
 | 200910 | 09
 | 200910 | 09
 | 200904 | 09
 | 200808 | 08
 | 200804 | 08
 | 200710 | 07
 | 200811 | 08
 | 200902 | 09
 | 200712 | 07
 | 200806 | 08
 | 200908 | 09
 | 200809 | 08
 | 200805 | 08
 | 200912 | 09
 | 200712 | 07
 | 200805 | 08
 | 200911 | 09
 | 200808 | 08
 | 200911 | 09
 | 200710 | 07
 | 200906 | 09
 | 200908 | 09
 | 200911 | 09
 | 200904 | 09
 | 200710 | 07
 | 200907 | 09
 | 200903 | 09
 | 200907 | 09
 | 200804 | 08
 | 200906 | 09
 | 200907 | 09
 | 200906 | 09
 | 200712 | 07
 | 200802 | 08
 | 200907 | 09
 | 200911 | 09
 | 201001 | 10
 | 200904 | 09
 | 200802 | 08
 | 200907 | 09
 | 200801 | 08
 | 200908 | 09
 | 200905 | 09
 | 200811 | 08
 | 200901 | 09
 | 200906 | 09
 | 200712 | 07
 | 200803 | 08
 | 200903 | 09
 | 200801 | 08
 | 200912 | 09
 | 200807 | 08
 | 200904 | 09
 | 200812 | 08
 | 200802 | 08
 | 200911 | 09
 | 200711 | 07
 | 200801 | 08
 | 201001 | 10
 | 200802 | 08
 | 200812 | 08
 | 200903 | 09
 | 200805 | 08
 | 201002 | 10
 | 200906 | 09
 | 200909 | 09
 | 200910 | 09
 | 200907 | 09
 | 200808 | 08
 | 200712 | 07
 | 200710 | 07
 | 200710 | 07
 | 200907 | 09
 | 200806 | 08
 | 200712 | 07
 | 200904 | 09
 | 200811 | 08
 | 200812 | 08
 | 200812 | 08
 | 200908 | 09
 | 200712 | 07
 | 200803 | 08
 | 200906 | 09
 | 201002 | 10
 | 200805 | 08
 | 200802 | 08
 | 200906 | 09
 | 200804 | 08
 | 200810 | 08
 | 200808 | 08
 | 200911 | 09
 | 200803 | 08
 | 200903 | 09
 | 200902 | 09
 | 201002 | 10
 | 200806 | 08
 | 200912 | 09
 | 200906 | 09
 | 201002 | 10
 | 201001 | 10
 | 200903 | 09
 | 200806 | 08
 | 200903 | 09
 | 200801 | 08
 | 200802 | 08
 | 200910 | 09
 | 200712 | 07
 | 200901 | 09
 | 200912 | 09
 | 200801 | 08
 | 200806 | 08
 | 200811 | 08
 | 200811 | 08
 | 200902 | 09
 | 200907 | 09
 | 200812 | 08
 | 200803 | 08
 | 200812 | 08
 | 200912 | 09
 | 200804 | 08
 | 200911 | 09
 | 200901 | 09
 | 200905 | 09
 | 200912 | 09
 | 200803 | 08
 | 200906 | 09
 | 200805 | 08
 | 200802 | 08
 | 200805 | 08
 | 200801 | 08
 | 200804 | 08
 | 200811 | 08
 | 200812 | 08
 | 200909 | 09
 | 200806 | 08
 | 200907 | 09
 | 200811 | 08
 | 200907 | 09
 | 200911 | 09
 | 200910 | 09
 | 200910 | 09
 | 200809 | 08
 | 200806 | 08
 | 200904 | 09
 | 200801 | 08
 | 200908 | 09
 | 200811 | 08
 | 200903 | 09
 | 200812 | 08
 | 200902 | 09
 | 200810 | 08
 | 200807 | 08
 | 200807 | 08
 | 200805 | 08
 | 201002 | 10
 | 200902 | 09
 | 200808 | 08
 | 200912 | 09
 | 200905 | 09
 | 200803 | 08
 | 201002 | 10
 | 200903 | 09
 | 200712 | 07
 | 201001 | 10
 | 201001 | 10
 | 200809 | 08
 | 200905 | 09
 | 201002 | 10
 | 200902 | 09
 | 200912 | 09
 | 201002 | 10
 | 200802 | 08
 | 200806 | 08
 | 200807 | 08
 | 200801 | 08
 | 200806 | 08
 | 200908 | 09
 | 201001 | 10
 | 200807 | 08
 | 200804 | 08
 | 200711 | 07
 | 200902 | 09
 | 200803 | 08
 | 200710 | 07
 | 200911 | 09
 | 200804 | 08
 | 200712 | 07
 | 201002 | 10
 | 200806 | 08
 | 200807 | 08
 | 200803 | 08
 | 200907 | 09
 | 201002 | 10
 | 200910 | 09
 | 200810 | 08
 | 200906 | 09
 | 201002 | 10
 | 201001 | 10
 | 200801 | 08
 | 200803 | 08
 | 200912 | 09
 | 200807 | 08
 | 200906 | 09
 | 200901 | 09
 | 200805 | 08
 | 200802 | 08
 | 201002 | 10
 | 200903 | 09
 | 200903 | 09
 | 200809 | 08
 | 200811 | 08
 | 200902 | 09
 | 200908 | 09
 | 200912 | 09
 | 201001 | 10
 | 200810 | 08
 | 200808 | 08
 | 200807 | 08
 | 200712 | 07
 | 200710 | 07
 | 200809 | 08
 | 200907 | 09
 | 200801 | 08
 | 200711 | 07
 | 200908 | 09
 | 200710 | 07
 | 200903 | 09
 | 200910 | 09
 | 200711 | 07
 | 200907 | 09
 | 200910 | 09
 | 200907 | 09
 | 200903 | 09
 | 201001 | 10
 | 200710 | 07
 | 200904 | 09
 | 200904 | 09
 | 200811 | 08
 | 200806 | 08
 | 200907 | 09
 | 201002 | 10
 | 200912 | 09
 | 200806 | 08
 | 200808 | 08
 | 200808 | 08
 | 200812 | 08
 | 200711 | 07
 | 200802 | 08
 | 200710 | 07
 | 200902 | 09
 | 200907 | 09
 | 200902 | 09
 | 201001 | 10
 | 200812 | 08
 | 201002 | 10
 | 200808 | 08
 | 201002 | 10
 | 200904 | 09
 | 200912 | 09
 | 200804 | 08
 | 201001 | 10
 | 200905 | 09
 | 200710 | 07
 | 200909 | 09
 | 200710 | 07
 | 200809 | 08
 | 200806 | 08
 | 200812 | 08
 | 200710 | 07
 | 200811 | 08
 | 200909 | 09
 | 200811 | 08
 | 200801 | 08
 | 200909 | 09
 | 200908 | 09
 | 200906 | 09
 | 200802 | 08
 | 200904 | 09
 | 200711 | 07
 | 200812 | 08
 | 201001 | 10
 | 200906 | 09
 | 200805 | 08
 | 200805 | 08
 | 200904 | 09
 | 200806 | 08
 | 200806 | 08
 | 200710 | 07