if you change the date 1/12/2015 to 1/11/2015 on A31 Cell then the Cell F48 value should appear its not appearing