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.

SAP Quote Number​	Previous Quote Number	Active Quotes	Start Date	End Date
HSG/12345678		Inactive	1/7/2015	2/7/2016
HSG/12345679	HSG/12345678	Inactive	1/8/2015	2/7/2016
HSG/12345680	HSG/12345679	Active	4/8/2015	2/7/2016
HSG/12345681			25/06/2015	2/7/2016

<tbody>
</tbody>

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.