If statement with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Excel2003 with sp2. I want to track expiration dates of memberships

I want to say: If m3 is blank make N3 blank and if M3 has a date, make N3
one year later.

How do I do this?

Thanks in advance,
Vivian
 
This works great for incrementing the dates. I either don't know how to read
the formula or it doesn't address the issue of M3 being blank then making N3
blank. I would like the formula to include either/or. Maybe it would be
better if I said, If M3 is blank then make N3 blank OR if M3 has a date make
N3 one year later.
 
The formula is testing cell M3 to see if it has a true Excel date. That's
what:

=IF(ISNUMBER(M3)

is doing. True Excel dates are just numbers formatted to look like a date.
If you're having problems it may be due to not having a true Excel date but
a TEXT string that looks like a date.

What are ALL of the possible types of entries that can be in cell M3? Just a
date or left empty? No TEXT entries, right? If that's the case the formula
should work if the cell contains a true Excel date.

Test the "date" and make sure it's a real date:

=ISNUMBER(M3) should return TRUE.

Biff
 
Back
Top