While I can't post a file, in the example Tony posted on 11/3/16 at 7pm, if cell C6 is changed to 3/29/16, I would expect cell G2 to change to 1. With the current formula, if cell C6 is changed to 3/2/16, cell G2 changes to #NUM!.