No return for formula
 

Using formula - =if($f5"0",f5-e5,"") returns no response.

trying to get the difference b etwwen 2 dates where "F" column is day
vehicle left and "E" column is day vehicle arrived.

Is my formula wrong?

No return for formula
 

Try removing the quotation marks from around 0
=if($f50,f5-e5,"")

"MPAVLAS" wrote:

Using formula - =if($f5"0",f5-e5,"") returns no response.

trying to get the difference b etwwen 2 dates where "F" column is day
vehicle left and "E" column is day vehicle arrived.

Is my formula wrong?

No return for formula
 

Hi

I think you need
=IF($F50,F5-E5,"")
Format the cell as General.
From your description, I'm not sure which is the later date.
As long a column F is later than column E, then it will be fine. Otherwise
you will need to reverse the calculation.

--
Regards
Roger Govier



"MPAVLAS" wrote in message
...
Using formula - =if($f5"0",f5-e5,"") returns no response.

trying to get the difference b etwwen 2 dates where "F" column is day
vehicle left and "E" column is day vehicle arrived.

Is my formula wrong?