Greetings. . .

I need help and fast. My boss is breathing down my neck. I am trying to
create a formula using dates. I understand Excel converts a date into a
number. Is this correct? For example, 9/9/2008 equals 39700, right?
G2 = 9/9/2008
I2 = 9/10/2005
1095 = 3 years

Here the formula:
IF G21 then H2=G2, but IF G2<1 then H2=I2+1095

Thanks so much!
Just in case you forget. . . my email address is

Yes 9/9/2008 is 39700.

Use this in H2
=IF(G21, G2, IF(G2<1,I2+1095,"What do you want here?"))

If you are sure that G2 won't be equal to 0
then
=IF(G21, G2, I2+1095)

"Brockjr38" wrote:

Greetings. . .

I need help and fast. My boss is breathing down my neck. I am trying to
create a formula using dates. I understand Excel converts a date into a
number. Is this correct? For example, 9/9/2008 equals 39700, right?
G2 = 9/9/2008
I2 = 9/10/2005
1095 = 3 years

Here the formula:
IF G21 then H2=G2, but IF G2<1 then H2=I2+1095

Thanks so much!
Just in case you forget. . . my email address is