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

  • Thread starter Thread starter chrise
  • Start date Start date
C

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.
 
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")
 
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
 
Back
Top