Usually caused by the selection of dates that are not recognized (formatting). Most Analytics Edge connectors will recognize Excel dates in cell references, or a combination of options that defines a range of dates (start+duration or start+end or duration+end).
Confirm that cell references used point to the cells that contain the dates (sometimes worksheet changes move the cell locations).