Date is text entry its actually coming from a WEBi report on portal , coming in Xcelsius, but i have used Excel on top of it. the first formula wont work as the date in the first field can change from 1 to 4. the dates are dynamic and they can change any time a new report is generated thats why i need an if to see what the first number is.

i could change the format to MM/YYYY.