If statement with dates

[Vivian H.]

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

 

[Biff]

Enter this formula in N3:

=IF(ISNUMBER(M3),DATE(YEAR(M3)+1,MONTH(M3),DAY(M3)),"")

Biff

 

[Vivian H.]

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.

 

[Biff]

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

 

[Vivian H.]

Thanks,Biff. I got it to work and it's fine now.
Vivian

 

[Biff]

Good deal!

Biff

Thanks,Biff. I got it to work and it's fine now.
Vivian