I want to enter some data into a cell dependant upon a date range.

If the date in cell €œA€� is between 1-Dec-06 and 28-Feb-07 return 02-07 into
cell €œB€�
If the date in cell €œA€� is between 1-Mar-07 and 31-May-07 return 05-07 into
cell €œB€�
If the date in cell €œA€� is between 1-June-07 and 31-Aug-07 return 08-07 into
cell €œB€�
If the date in cell €œA€� is between 1-Sep-07 and 30-Nov-07 return 11-07 into
cell €œB€�
If the date in cell €œA€� is between 1-Dec-07 and 28-Feb-08 return 02-08 into
cell €œB€�

Etc - Etc

--
Cheers

Andy