Comparing dates in two colums...one cell is blank.

[piggle]

Hi,

Just a quick question. I am comparing project completion dates in a worksheet. Column G is the forcast completion date, and column H is the actual completion date. The formula in column I compares the two dates and give a result of "Y" or "N".

PROJECT COMPLETION STATUS.xls
	G	H	I	J
10	Original Approved Project Completion Date	Actual Project Completion Date	Completed On Time	Comment
11
12	30-Sep-05	30-Sep-05	Y
13	30-Jun-05	30-Aug-05	N
14	24-Jun-05	11-Jul-05	N
15	31-Aug-05	14-Sep-05	N
16	01-Jun-05		Y
17	30-Jun-05	30-Jun-05	Y
18	01-Jun-05	29-Sep-05	N
19	30-Jun-05	30-Aug-05	N
20	30-Jun-05	01-Jul-05	N
PROJECT COMPLETION STATUS

My issue is that if the cell in column H is blank, how do I change the formula to bring a result of "N/A"?

Thanks in advance,

Anton.

 

[eliW]

Try:

=IF(H16,IF(G16>=H16,"Y","N"),NA())

Eli