Formula Help to Calculate Date based off a Date in another cell

[rlfett]

I have a "Ship to Arrive" Column, this column almost always has a manually entered date. The cell is formatted for date. But occasionally it will be Blank or have text like Hold entered into it.

I have got close but my problem is if Blank or Text not a date I get something like #### etc populating into the destination cell.

F5 is my 1st "Ship to Arrive" Cell, G5 I would like to auto populate 14 Days prior to what ever date is typed into F5. However if Blank or Random Text "Hold" is entered into F5 I wish
to see a blank cell in G5 nothing more.

This formula will be for the entire column in each Row F and G.

Thanks,

[PaulM100]

Try: =if(or(f5="",f5="Hold"),"",G5-14)

[Special-K]

Try: =if(or(f5="",f5="Hold"),"",G5-14)

That should be F5-14
"14 Days prior to what ever date is typed into F5"
Also the formula is being entered into G5 which would have produced a circular reference.
So

in G5
=if(or(F5="",F5="Hold"),"",F5-14)

[PaulM100]

Good catch, totally missed that as I was typing it.

[Special-K]

Oh dear, then I'm not as drunk as I thought I was!

[rlfett]

Thanks all for the help! Worked like a charm!