If/Then Formula Question: Can Excel Be Made to Read the Computer's Date Setting?

[chrise]

This might be asking a bit much of Excel, but here goes.

I have a membership list. When you pay your membership it is good for
one year. I enter the expiration date in cell A1. In cell B1 I want to
have an If/Then formula that states Y if their membership is active, N
if it isn't.

My issue is that each person's expiration date is different, so my
formula in column B will be different for everyone. I want to be able
to have the If/Then function look at the computer's date as part of
the function. i.e.

The normal way is listed below, but each person would need a different
day in order for the formula to be accurate.
=If(A1>=--(2004,1,31),"Y","N")

Would I would like to do is change this formula to something that would
make Excel know what today's date is, so that every cell would be
updated. Something like this:
=If(A1>=--(today's date),"Y","N")

How can I do this? Thanks for your help.

 

[Dave Peterson]

I'm surprised this worked at all:

=If(A1>=--(2004,1,31),"Y","N")

But this should:
=If(A1>=date(2004,1,31),"Y","N")

as well as:

=If(A1>=today(),"Y","N")

 

[Niek Otten]

Make sure you enter the expiry dates as real Excel dates. Then you can use
the formula

=If(A1>TODAY(),"Y","N")

Assumed you have your system clock set correctly

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Harald Staff]

Sure
=IF(A1>=TODAY(),"Y","N")

HTH. Best wishes Harald

 

[chrise]

That was awsome. Thanks!