If/OR formula

Jennifer Dewhurst

I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A".  Here's what I have so far:

 

=IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)

 

The lowest number the result can be will be 1.  What am I doing wrong?  Any guidance given is greatly appreciated.

 

Thanks all.

Chris S

Hi,

 

Shouldn't it be the following?

 

=IF(OR([Initial Approval]1 = "", [Request for PR]1 = "", [Initial Approval]1 = "N/A", [Request for PR]1 = "N/A"), "N/A", [Request for PR]1 - [Initial Approval]1 + 1)

 

This will return N/A if any of the dates is empty or calculate the difference if there are dates in both.

 

I hope that helps.