Create table #sample
 (Itemid nvarchar(1),ConfirmedDate datetime)
 go
 insert into #sample(itemid,ConfirmedDate) values ('A','2013-11-25 00:00:00.000')
insert into #sample(itemid,ConfirmedDate) values ('A','2013-11-27 00:00:00.000')
insert into #sample(itemid,ConfirmedDate) values ( 'A','2013-11-28 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('A','2013-12-01 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('B','2013-12-24 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('B','2013-12-26 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('B','2014-01-01 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('B','2014-01-08 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('C','2014-01-25 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('C','2014-01-28 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('C','2014-02-20 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('C','2014-02-24 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('D','2014-02-28 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('D','2014-03-01 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('D','2014-03-25 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('D','2014-03-28 00:00:00.000')
 insert into #sample(itemid,ConfirmedDate) values ('D','2099-01-01 00:00:00.000')
 
 select 
	Itemid
	,ConfirmedDate 
	,Case When ConfirmedDate between('11/26/2013') AND('12/25/2013') THEN 'DEC ETA'
	     When ConfirmedDate between('12/26/2013') AND('1/25/2014') THEN 'JAN ETA'
	     When ConfirmedDate between('1/26/2014') AND('2/25/2014') THEN 'FEB ETA'
	     When ConfirmedDate between('2/26/2014') AND('3/25/2014') THEN 'MAR ETA'
         When ConfirmedDate between('3/26/2014') AND('4/25/2014') THEN 'APR ETA'
      Else 'NO ETA' END AS Remarks
From #sample

..
Case When ConfirmedDate between DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,-4) AND DATEADD(mm,DATEDIFF(mm,0,GETDATE())+2,-5) THEN 'DEC ETA'
	     When ConfirmedDate between DATEADD(mm,DATEDIFF(mm,0,GETDATE())+2,-4) AND DATEADD(mm,DATEDIFF(mm,0,GETDATE())+3,-5) THEN 'JAN ETA'
	     ...

quote:

---

Originally posted by Villanuev

Hi Visakh, did you know any forum for excel ( Macro issue) to help me. thanks.

---