View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Vivian H. Vivian H. is offline
external usenet poster
 
Posts: 5
Default If statement with dates

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

"Biff" wrote:

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." wrote in message
...
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" wrote:

Enter this formula in N3:

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

Biff

"Vivian H." wrote in message
...
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