If statement with dates
 

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

If statement with dates
 

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

If statement with dates
 

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

If statement with dates
 

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

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

If statement with dates
 

Good deal!

Biff

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