Newbie Excel Question

[Romer]

Hi guys,

Im new here and not an expert in Excel and i have a simple question hoping you guys can answer.

[TABLE="width: 500"]
<tbody>[TR]
[TD]

SAP Quote Number​

[/TD]
[TD]Previous Quote Number[/TD]
[TD]Active Quotes[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[/TR]
[TR]
[TD]HSG/12345678[/TD]
[TD][/TD]
[TD]Inactive[/TD]
[TD]1/7/2015[/TD]
[TD]2/7/2016[/TD]
[/TR]
[TR]
[TD]HSG/12345679[/TD]
[TD]HSG/12345678[/TD]
[TD]Inactive[/TD]
[TD]1/8/2015[/TD]
[TD]2/7/2016[/TD]
[/TR]
[TR]
[TD]HSG/12345680[/TD]
[TD]HSG/12345679[/TD]
[TD]Active[/TD]
[TD]4/8/2015[/TD]
[TD]2/7/2016[/TD]
[/TR]
[TR]
[TD]HSG/12345681[/TD]
[TD][/TD]
[TD][/TD]
[TD]25/06/2015[/TD]
[TD]2/7/2016[/TD]
[/TR]
</tbody>[/TABLE]

Im trying to automate the Active Quotes column by doing a formula but i cant seem to figure it out.

Basically if the Column A has a new Quotation it will be active on the start date and it will be deactivated once a new quotation has been created to replace the first quote or if the end date has reach.

Cant seem to figure it out. this is the formula that im using but i dont get the right answer.
=IF(B6>=1,"Active",IF(AND(TODAY()>=N6,TODAY()<=O6),"Active","Inactive"))

Hope you guys can help me.

Thanks & Peace out,

 

[Romer]

Thanks gaz, I think my comp just need to sleep.

I think its working now.

You've been very helpful and patient.

 

[gaz_chops]

You're welcome.