try
=DATE(YEAR(A1+31),CHOOSE(MONTH(A1),2,2,5,5,5,8,8,8 ,11,11,11,2),1)
formatted as mm-yy

"ANDY" wrote:

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