Hi - I have a set of rows which has column 'shift' missing. I need to fill the column 'shift' based on the date, for example -

# Date Shift
1 01/04/2014 A
2 02/04/2014 A
3 02/04/2014 B
4 03/04/2014 A
5 03/04/2014 B
6 03/04/2014 C
7 04/04/2014 A
8 04/04/2014 B


etc.


Kindly help to write a formula for filling in the shifts for every dates.

Thanks
MK