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.
That answer is accurate, as the difference between 0 and today is 41918 days. Instead, put an IF statement to avoid the calculation if H1 is blank.
=IF(H1="","",DATEDIF(H1,TODAY(),"d"))
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Try this:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Hi,
Maybe
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks