Hi

I work in the Travel industry and i pay Tour Operators.

At the moment one of my operators lets say My Travel sends in a statement with a supplier ref on it but my branch inputs the supplier reference with a season for example

Statement Ref 123456
Branch Ref 123456/S07

Now what i need to do is seasons are dependant on dep date i need to write a formula that does the following

Say Season S07 is dep date from 1/5/6 to 1/10/6. I need to write a sum that looks in a dep date column looks at the date and if the date falls between the two from and to dates then add "S07" I would also repeat this process for W07 etc etc.

Any ideas please?

Regards

Clint