If AND Formula

[jo.stanley]

I need to calculate the following. can anyone please assist?

If F1 = Value then F1-D1 or if E1= Value then E1-D1. If F1 or E1 are blank than cell to remain empty

 

[JackDanIce]

I'm afraid this is not clear and you're not showing a picture of your spreadsheet that's in front of you. Please state:

The cell the formula needs to be in
What is in D1, E1 and F1?
What is the "value" and what cell is the "value" in?

At a guess, you can adjust:

=IF(LEN(F1)*LEN(E1)=0,"",-D1+IF(F1=value,F1,IF(E1=value,E1,0)))

 

[jo.stanley]

Hi

Sorry its not clear. Im afraid I cant show a pic so ill try and explain clearer

Column D always has a date in it
Column E and F sometimes have a date in either one but not in both

What I want to calculate is the number of days that has elapsed between the two dates but if there is only a date in Column D then the cell will remain blank. The formula I am currently using is =IF(ISBLANK(F4)=FALSE,(F4-D4),(E4-D4))

But it is returning a large negative value E and F are blank

 

[JackDanIce]

Try:

=IF(LEN(E4)*LEN(F4)=0,"",MAX(F4-D4,E4-D4))

 

[jo.stanley]

Unfortunately its returning a blank

 

[JackDanIce]

Try:

=IF(LEN(E4)+LEN(F4)=0,"",MAX(F4,E4)-D4)