"if" formula

[Kiki]

Hi helper,

I want to use "if formula" to determine the status. Attached the
below list for your assistance. Duration is 2 years. Eg, if the start
date is 5 May 08, the end date should be 4 May 2010 since the duration
is 2 years. the status should be inactive but under column c, it is
still active.

Column A Column B Column C
START_DATE END_DATE STATUS
5-May-08 4-May-10 Active
5-May-08 4-May-10 Active
3-Nov-08 2-Nov-10 Active
3-Nov-08 2-Nov-10 Active

Thank you.

 

[joeu2004]

if the start date is 5 May 08, the end date should be
4 May 2010 since the duration is 2 years. the status
should be inactive but under column c, it is still active.

You're not being very clear. But I think you want the following in C2
and copy down:

=IF(B2>=TODAY(),"Active","Inactive")

or:

=IF(AND(A1<=TODAY(),B2>=TODAY()),"Active","Inactive")

The latter is needed only if the start date might be a future date.


PS: For broader participation, you might want to post future
inquiries using the MS Answers Forums at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel.
It's not that I like that forum. It's just that MS has ceased to
support the Usenet newsgroups. Hence, participation here is limited
to
the sites that share a common newsgroup mirror, which is no longer
centralized at MS.


----- original message -----

 

[Ken Mintz]

Errata....

=IF(AND(A1<=TODAY(),B2>=TODAY()),"Active","Inactive")

That should be:

=IF(AND(A2<=TODAY(),B2>=TODAY()),"Active","Inactive")


----- original message -----

 

[joeu2004]

Errata (minor typo)....

=IF(AND(A1<=TODAY(),B2>=TODAY()),"Active","Inactive")

Should be:

=IF(AND(A2<=TODAY(),B2>=TODAY()),"Active","Inactive")


----- original message -----