I've created a custom field that compares today's date versus a user entered date.  The result does not update or show correctly in reports or the views. 

What's the benefit of having a custom field / formula if you have to edit the record every time to get it updated?

Ceil(Datecomp(${Products.Project End Date},Newdate(Year(Now()),Month(Now()),Dayofmonth(Now()),01,01,'AM'))/60/24)