Creating seperate excel based on dates

Need to include 123 also ,if it’s 123 and it has year need to split