Excel 2007 : If Statements to return "-" if no dates exists

Hi -

I am trying to create a formula where i find the max of 2 date columns then do a simple calculation subtracting the max date from a start date, then convert into hours.

Formula: =(MAX(ActualProjectRequirement!G5:H5)-(ActualProjectRequirement!D5))*(24/3)

The problem I have is that some of the date fields where the MAX function is used will be blank so I want to create a statement where this calcualtion is performed only when a date is present and return a "-" when no date. I tried a few if statments but was unsuccessful. Any help would be great!

Thanks!

B

Try

=IF(OR(G5="",H5=""),"-",(MAX(ActualProjectRequirement!G5:H5)-(ActualProjectRequirement!D5))*(24/3))