Formula required

[Shweta]

Hi All,

Please help me out on the below query. I have the following data in column A

6/25/2012
6/28/2012
7/03/2012
7/04/2012
7/18/2012
8/09/2012
8/27/2012.....and so on

In column B I want output with the below conditions

if date is >=1-Jun-12 and <15-Jun-12 then show "<15"
if date is >=15-Jun-12 and <=30 then show "<30"
if date is >=1-Jul-12 and <=30-Jul-12 then show "<60"
if date is >=1-Aug-12 and <=30-Aug-12 then show "<90" Please provide me a formula for this. Thanks in advance! Regards, Shweta

<colgroup><col span="6"></colgroup><tbody>
</tbody>

 

[radiant0619]

Hi Shweta

pls find the below formula as requested by you

=IF(AND(A2>=DATE(2012,6,1),A2<DATE(2012,6,15)),"< 15",IF(AND(A2>=DATE(2012,6,15),A2<=DATE(2012,6,30)),"< 30",IF(AND(A2>=DATE(2012,7,1),A2<=DATE(2012,7,31)),"< 60",

regards
Sakthivel R