I am trying to do an IF statement. I have a date in cell I3 (example 12/9/2015) and a date in cell F4 (example 1/8/16). In cell I4 I want a formula that states if F4 is greater than I3 copy cell H4 to cell I4. Is this possible and what would the statement be? Thank you

In I4:
IF(F4>I3,H4,"")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you. That worked. Is it also possible to do the statement a between statement, for example if f4 (2/3/16) is between I3 ((12/27/15 - (1/23/16) copy h4 and if false add a "0" to I4? Appreciate the help.

Where are the two dates you want to compare stored? One is apparently in I3, but where is the other (or is it calculated from the value in I3)?

As for inserting a 0, simply change:
IF(F4>I3,H4,"")
to:
IF(F4>I3,H4,0)

Note: This is all very basic Excel stuff. I suggest you read a book on using Excel.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]