I am trying to report on a total number of days from a certain date until today.
The formula I am using is:=DATEDIF(H1,TODAY(),"d"), where H1=the certain day's date
The cell containing the result has 41918, and I am wondering why or if it is possible to change it so that it does not confuse the staff members who will be entering data into this form. There is no data in H1 yet. Please help. Thanks.