If Statement with Datedif and Blanks

**mtr1213** · 08-11-2014, 04:21 PM

Hello -Attached I'm trying to track the days when a Hiring Package is Sent/Offer Accepted or Declined.

My formula only seems to be measuring the days between Sent to Accepted but if Accepted is Blank look at Declined and say "Offer Declined"

MTR

**cbatrody** · 08-11-2014, 04:27 PM

Hi,

Please modify the formula in D5 as following & drag down-

=IF(OR(A5="",AND(B5="",C5=""))," ",IF(C5="",(DATEDIF(A5,B5,"d")),(DATEDIF(A5,C5,"d"))))

**daddylonglegs** · 08-11-2014, 05:32 PM

For date difference in days you don't really need DATEDIF, a simple subtraction will give the number of days - try this formula in D5 copied down

=IF(COUNT(B5:C5),IF(B5,B5,C5)-A5,"")