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
|